J.12_Attachment_12.xlsx

XLSX spreadsheet 97 KB Posted Aug 9, 2019

Attached to: Business Applications Solution - Request for Proposal
Solicitation number: 1331L519R13OS0005
Issued by: Department of Commerce Office of the Secretary

About this file

Written by GovTribe AI · Dec 28, 2023

This is a pricing schedule for a firm-fixed-price contract to provide a business applications solution to the Department of Commerce Office of the Secretary. The contract includes implementation of an enterprise data warehouse and business intelligence capability along with hosting and operations and maintenance for the Department of Commerce bureaus NOAA, NIST and Census. Pricing is provided for base and option periods from 2020 to 2040. The schedule includes details of deliverables and pricing for project management, implementation, operations and maintenance and hosting activities. Labor categories and hourly rates are also provided to cover any optional time and materials work over the life of the contract.

From the source

J.12 Attachment 12 - Price Schedule

View the file

Other files

File	Type	Posted
1331L519R13OS0005_A003.pdf	PDF	Sep 24, 2019
1331L519R13OS0005_A002.pdf	PDF	Sep 20, 2019
1331L519R13OS0005_Response_to_Inquiries_Follow-up.pdf	PDF	Sep 20, 2019
J.10_Attachment_10_A001.pdf	PDF	Sep 13, 2019
1331L519R13OS0005_A001_conformed.pdf	PDF	Sep 13, 2019
J.12_Attachment_12_A001.xlsx	XLSX spreadsheet	Sep 13, 2019
J.11_Attachment_11_A001.pdf	PDF	Sep 13, 2019
1331L519R13OS0005_A001_SF30.pdf	PDF	Sep 13, 2019
J.1_Attachment_01_A001.xlsx	XLSX spreadsheet	Sep 13, 2019
J.15_Attachment_15.pdf	PDF	Sep 13, 2019
1331L519R13OS0005_A001_tracked_changes.pdf	PDF	Sep 13, 2019
J.7_Attachment_07_A001.pdf	PDF	Sep 13, 2019
J.14_Attachment_14.docx	DOCX document	Sep 13, 2019
1331L519R13OS0005_Responses_to_Inquiries.pdf	PDF	Sep 5, 2019
J.11_Attachment_11.pdf	PDF	Aug 9, 2019
J.3_Attachment_03.pdf	PDF	Aug 9, 2019
J.10_Attachment_10.pdf	PDF	Aug 9, 2019
J.5_Attachment_05.pdf	PDF	Aug 9, 2019
J.4A_Attachment_04A.pdf	PDF	Aug 9, 2019
J.7_Attachment_07.pdf	PDF	Aug 9, 2019
J.1_Attachment_01.pdf	PDF	Aug 9, 2019
1331L519R13OS0005_BAS_Final_RFP.pdf	PDF	Aug 9, 2019
J.13_Attachment_13.xlsx	XLSX spreadsheet	Aug 9, 2019
J.6_Attachment_06.pdf	PDF	Aug 9, 2019
J.8_Attachment_08.pdf	PDF	Aug 9, 2019
J.4B_Attachment_04B.pdf	PDF	Aug 9, 2019
J.2_Attachment_02.pdf	PDF	Aug 9, 2019
J.9_Attachment_09.pdf	PDF	Aug 9, 2019
1331L519R13OS0005_BAS_Draft_RFP.pdf	PDF	Jul 12, 2019
BAS_Draft_Performance_Work_Statement.pdf	PDF	Jul 12, 2019
BAS_Notional_CLIN_Structure_FFP.pdf	PDF	Jul 12, 2019
Draft_RFP_&_PWS_Question_and_Comment_Template.xlsx	XLSX spreadsheet	Jul 12, 2019

Show all 32

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.

Instructions

Summary Level Pricing

CLIN	Description	Anticipated PoP	Firm Fixed Price
Base Period
0001	Project Management Services	4/1/20 - 3/31/21	0
0002	EDW and Reporting Capability	4/1/20 - 3/31/21	0
0003	Phase 1 Implementation (NOAA), Part 1	4/1/20 - 3/31/21	0
0004	Hosting	4/1/20 - 3/31/21	0
Total			0
Option Period 1
0101	Project Management Services	4/1/21 - 3/31/22	0
0102	EDW and Reporting Capability	4/1/21 - 3/31/22	0
0103	Phase 1 Implementation (NOAA), Part 2	4/1/21 - 3/31/22	0
0104	Hosting	4/1/21 - 3/31/22	0
Total			0
Option Period 2
0201	Project Management Services	4/1/22 - 3/31/23	0
0202	EDW and Reporting Capability	4/1/22 - 3/31/23	0
0203	Phase 1 Implementation (NOAA), Part 3 and Deploy	4/1/22 - 10/31/22	0
0204	Phase 2 Implementation (NIST), Part 1	10/1/22 - 3/31/23	0
0205	O&M Services - NOAA	10/1/22 - 3/31/23	0
0206	Hosting	4/1/22 - 3/31/23	0
Total			0
Option Period 3
0301	Project Management Services	4/1/23 - 3/31/24	0
0302	EDW and Reporting Capability	4/1/23 - 3/31/24	0
0303	Phase 2 Implementation (NIST), Part 2 and Deploy	4/1/23 - 10/31/23	0
0304	O&M Services - NIST	10/1/23 - 3/31/24	0
0305	Phase 3 Implementation (Census), Part 1	10/1/23 - 3/31/24	0
0306	O&M Services - NOAA	4/1/23 - 3/31/24	0
0307	Hosting	4/1/23 - 3/31/24	0
Total			0
Option Period 4
0401	Project Management Services	4/1/24 - 3/31/25	0
0402	EDW and Reporting Capability	4/1/24 - 3/31/25	0
0403	Phase 3 Implementation (Census), Part 2 and Deploy	4/1/24 - 10/31/24	0
0404	O&M Services - Census	10/1/24 - 3/31/25	0
0405	O&M Services - NOAA and NIST	4/1/24 - 3/31/25	0
0406	Hosting	4/1/24 - 3/31/25	0
Total			0
Option Period 5
0501	Hosting and O&M Services	4/1/25 - 3/31/26	0
Option Period 6
0601	Hosting and O&M Services	4/1/26 - 3/31/27	0
Option Period 7
0701	Hosting and O&M Services	4/1/27 - 3/31/28	0
Option Period 8
0801	Hosting and O&M Services	4/1/28 - 3/31/29	0
Option Period 9
0901	Hosting and O&M Services	4/1/29 - 3/31/30	0
Option Period 10
1001	Hosting and O&M Services	4/1/30 - 3/31/31	0
Option Period 11
1101	Hosting and O&M Services	4/1/31 - 3/31/32	0
Option Period 12
1201	Hosting and O&M Services	4/1/32 - 3/31/33	0
Option Period 13
1301	Hosting and O&M Services	4/1/33 - 3/31/34	0
Option Period 14
1401	Hosting and O&M Services	4/1/34 - 3/31/35	0
Option Period 15
1501	Hosting and O&M Services	4/1/35 - 3/31/36	0
Option Period 16
1601	Hosting and O&M Services	4/1/36 - 3/31/37	0
Option Period 17
1701	Hosting and O&M Services	4/1/37 - 3/31/38	0
Option Period 18
1801	Hosting and O&M Services	4/1/38 - 3/31/39	0
Option Period 19
1901	Hosting and O&M Services	4/1/39 - 3/31/40	0
Total Firm Fixed Pricing
Base Plus All Option Periods FFP Combined			0
Optional T&M Support for EAS Migration, Hosting and O&M Services; Enhancements; and Transition Support Services
CLIN	Description	Anticipated PoP	Ceiling Price*
2000	Base Period - Optional T&M Support	4/1/20 - 3/31/21	*
2001	Option Period 1 - Optional T&M Support	4/1/21 - 3/31/22	*
2002	Option Period 2 - Optional T&M Support	4/1/22 - 3/31/23	*
2003	Option Period 3 - Optional T&M Support	4/1/23 - 3/31/24	*
2004	Option Period 4 - Optional T&M Support	4/1/24 - 3/31/25	*
2005	Option Period 5 - Optional T&M Support	4/1/25 - 3/31/26	*
2006	Option Period 6 - Optional T&M Support	4/1/26 - 3/31/27	*
2007	Option Period 7 - Optional T&M Support	4/1/27 - 3/31/28	*
2008	Option Period 8 - Optional T&M Support	4/1/28 - 3/31/29	*
2009	Option Period 9 - Optional T&M Support	4/1/29 - 3/31/30	*
2010	Option Period 10 - Optional T&M Support	4/1/30 - 3/31/31	*
2011	Option Period 11 - Optional T&M Support	4/1/31 - 3/31/32	*
2012	Option Period 12 - Optional T&M Support	4/1/32 - 3/31/33	*
2013	Option Period 13 - Optional T&M Support	4/1/33 - 3/31/34	*
2014	Option Period 14 - Optional T&M Support	4/1/34 - 3/31/35	*
2015	Option Period 15 - Optional T&M Support	4/1/35 - 3/31/36	*
2016	Option Period 16 - Optional T&M Support	4/1/36 - 3/31/37	*
2017	Option Period 17 - Optional T&M Support	4/1/37 - 3/31/38	*
2018	Option Period 18 - Optional T&M Support	4/1/38 - 3/31/39	*
2019	Option Period 19 - Optional T&M Support	4/1/39 - 3/31/40	*
Total (*NOTE: A ceiling price for the optional T&M CLINs will be established at the time of award)			*

1331L519R13OS0005 Summary Level Pricing Attachment J.12

&P of &N

Base Period CLIN Detail

CLIN	Description	PWS Deliverable #	PWS Deliverable Name		Billable Milestone Amount
0001	Project Management Services	1	Draft Integrated Master Schedule
		2	Final Integrated Master Schedule Baseline
		4	Draft Schedule Management Plan
		5	Final Schedule Management Plan
		6	Draft Cost Management Plan
		7	Final Cost Management Plan
		8	Project Status Reports
		9	Analyses and Presentations
		10	EVM Analyses, Forecasts, and Performance Reports
		11	Draft Scope Definition and Management Plan
		12	Final Scope Definitation and Management Plan
		13	Draft Requirements Management Plan
		14	Final Requirements Management Plan
		15	Requirements Traceability Matrix
		16	Draft Quality Management Plan
		17	Final Quality Management Plan
		18	Draft Human Resources Management Plan
		19	Final Human Resources Management Plan
		20	Draft Staffing Management Plan
		21	Final Staffing Management Plan
		22	Draft Issue Management Plan
		23	Final Issue Management Plan
		24	Draft Project Information Management Plan
		25	Final Project Information Management Plan
		26	Draft Project Management Plan
		27	Final Project Management Plan
		28	Draft Integrated Project Change Contorl Plan
		29	Final Integrated Project Change Control Plan
		30	Draft Configuration Management Plan
		31	Final Configuation Management Plan
		32	Draft Security Management Plan
		33	Final Security Management Plan
		34	Draft Scope Management Plan
		35	Final Scope Management Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Project Management Activities		12	MO	0
Subtotal							0

0002	EDW and Reporting Capability	51	Draft High Level Operational Reporting Strategy and Recommendation
		54	Draft Operational Reports Requirements Documents
		78	Draft Data Model Governance Strategy
		82	Draft EDW Requirements Document
		83	Final EDW Requirements Document
		85	Draft EDW Architecture Detailed Design Document
		88	Draft Data Transfer Documentation
		91	Draft EDW/BI Implementation Approach
		103	Draft Reporting/BI Requirements
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required EDW and Reporting Activities		12	MO	0
Subtotal							0

0003	Phase 1 Implementation (NOAA), Part 1	36	System Configuration Options Catalog/Matrix
		37	Draft Detailed Implementation Approach Assessment
		38	Final Detailed Implementation Approach Assessment
		45	Draft Solution Design Document
		133	Draft Detailed Interface Strategy
		136	Draft Interface Requirements Documents
		193	Application Suite Draft Requirements Documents (Per Application)
		205	Draft Implementation Plan
		206	Final Implementation Plan
		214	Draft Overall Test Strategy
		226	Draft Organizational Change Management Plan
		227	Final Organizational Change Management Plan
		229	Draft Impact Assessment
		233	Draft Stakeholder Management Plan
		234	Final Stakeholder Management Plan
		236	Draft Implementation Communications Plan
		237	Final Implementation Communications Plan
		239	Draft Training Plan and Approach
		240	Updated Training Plan and Approach
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 1 Implementation Activities		12	MO	0
Subtotal							0

0004	Hosting	246	Draft IT Concept of Operations
		248	Draft Software Acquisitions Strategy
		249	Final Software Acquisitions Strategy
		257	Draft Archiving Strategy
		260	Draft Archiving Requirements
		261	Final Archiving Requirements
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Hosting Activities (reference data from "Hosting Worksheet Base & OY 1-4" Tab)		12	MO	0	0
Subtotal							0

Total 0

1331L519R13OS0005 Base Period CLIN Detail Attachment J.12

&P of &N

Option Period 1 CLIN Detail

CLIN	Description	PWS Deliverable #	PWS Deliverable Name		Billable Milestone Amount
0101	Project Management Services	3	Updated Integrated Master Schedule
		8	Project Status Reports
		9	Analyses and Presentations
		10	EVM Analyses, Forecasts and Performance Reports
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Project Management Activities		12	MO	0
Subtotal							0

0102	EDW and Reporting Capability	52	Final High Level Operational Reporting Strategy and Recommendation
		55	Final Operational Reports Requirements Documents
		57	Draft Operational Reports High Level Designs
		58	Final Operationsl Reports High Level Designs
		60	Draft Operational Reports Detailed Designs
		61	Final Operational Reports Detailed Designs
		63	Initial Operational Reports Code
		66	Draft Operational Reports Test Plan
		72	Draft Operational Reports Training Plan
		73	Final Operational Reports Training Plan
		75	Draft Operational Reports Deployment Plan
		76	Final Operational Reports Deployment Plan
		79	Final Data Model Governance Strategy
		80	Updated Canonical Data Model
		81	Updated Conceptual EDW Data Model
		84	Updated EDW Requirements Document
		86	Final EDW Architecture Detailed Design Document
		87	Updated EDW Architecture Detailed Design Document
		89	Final Required Data Transfer Documentation
		90	Updated Required Data Transfer Documentation
		92	Final EDW/BI Implenetation Approach
		93	Updated EDW/BI Implementation Approach
		94	Initial EDW Solution and Underlying Code Delivery
		97	Draft EDW Training Plan
		98	Final EDW Training Plan
		99	Updated EDW Training Plan
		100	Draft EDW Deployment Plan
		101	Final EDW Deployment Plan
		102	Updated EDW Deployment Plan
		104	Final Reporting/BI Requirements
		105	Updated/Additional Reporting/BI Requirements
		106	Draft Reporting/BI High Level Designs
		107	Final Reporting/BI High Level Designs
		108	Updated/Additional Reporting/BI High Level Designs
		109	Draft Reporting/BI Detailed Level Designs
		110	Final Reporting/BI Detailed Level Designs
		111	Updated/Additional Reporting/BI Detailed Level Designs
		115	Draft Reporting/BI Training Plan
		116	Final Reporting/BI Training Plan
		117	Updated Operationsl Reports Training Plan
		118	Draft Reporting/BI Deployment Plan
		121	Draft EDW Test Plan
		122	Final EDW Test Plan
		124	Draft Reporting/BI Test Plan
		125	Final Reporting/BI Test Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required EDW and Reporting Activities		12	MO	0
Subtotal							0

0103	Phase 1 Implementation (NOAA), Part 2	39	Draft BAS SOPs
		40	Final BAS SOPs
		41	Updated BAS SOPs
		42	Draft Fit Gap Analysis
		43	Final Fit Gap Analysis
		46	Final Solution Design Document
		48	Draft Functional Concept of Operations
		134	Final Detailed Interface Strategy
		135	Updated Detailed Interface Strategy
		137	Final Interface Requirements Documents
		138	Updated Interface Requirements Documents
		139	Draft Interface High Level Designs
		140	Final Interface High Level Designs
		141	Updated/Additional Interface High Level Designs
		142	Draft Interface Detailed Level Designs
		143	Final Interface Detailed Level Designs
		144	Updated/Additional Interface Detailed Level Designs
		145	Initial Interface Code for Each Interface
		148	Draft Interface Test Plan
		149	Final Interface Test Plan
		150	Updated Interface Test Plan
		154	Draft Interface SOPs
		157	Draft Interface Training Plan
		158	Final Interface Training Plan
		160	Draft Interface Deployment Plan
		163	Draft Detailed Conversion Strategy
		164	Final Detailed Conversion Strategy
		166	Detailed Legacy System Decommissioning Strategy
		171	Updated Interface Requirements Documents
		173	Final Conversion High Level Design
		174	Updated/Additional Conversion High Level Designs
		175	Draft Conversion Detailed Level Designs
		178	Initial Conversion Code
		181	Draft Conversion Test Plan
		182	Final Conversion Test Plan
		183	Updated Conversion Test Plan
		190	Draft Conversion Deployment Plan
		191	Final Conversion Deployment Plan
		194	Application Suite Final Requirements (Per Application)
		195	Application Suite Updated Requirements (Per Application)
		196	Draft Detailed Application Suite Requirements (Per Application)
		197	Final Detailed Application Suite System Configuration Documentation
		198	Updated Detailed Application Suite System Configuration Documentation
		199	Application Suite Draft Test Plan
		200	Application Suite Final Test Plan
		201	Appliccation Suite Updated Test Plan
		207	Updated Implementation Plan
		208	Updated RTM
		209	Financial Audit Strategy
		210	Draft Go Live Plan
		215	Final Overall Test Strategy
		217	Draft Overall Test Plan
		218	Final Overall Test Plan
		219	Updated Overall Test Plan
		220	Draft Test Scripts
		228	Updated Organizational Change Management Plan
		230	Final Impact Assessment
		231	Updated Impact Assessment
		232	Impact Analysis Tracking Log
		235	Updated Stakeholder Management Plan
		238	Updated Implementation Communications Plan
		241	Final Training Plan and Approach
		242	Draft Training Curriculum and Materials
		243	Final Training Curriculum and Materials
		244	Updated Training Curriculum and Materials
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 1 Implementation Activities		12	MO	0
Subtotal							0

0104	Hosting	247	Final IT Concept of Operations
		250	Updated Software Acquisitions Strategy
		251	Software Licenses or Softwre License Certification Letter
		255	Draft SLA, Including all related documents
		258	Final Archiving Strategy
		262	Updated Archiving Requirements
		263	Draft Archiving Design
		264	Final Archiving Design
		265	Updated Archiving Design
		269	Draft Archiving Test Plan
		270	Final Archiving Test Plan
		271	Updated Archiving Test Plan
		275	Draft Archiving SOPs
		278	Draft Archiving Training Plan
		279	Final Archiving Training Plan
		280	Updated Archiving Training Plan
		281	Draft Archiving Deployment Plan
		282	Final Archiving Deployment Plan
		283	Updated Archiving Deployment Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Hosting Activities (reference data from "Hosting Worksheet Base & OY 1-4" Tab)		12	MO	0	0
Subtotal							0

Total 0

1331L519R13OS0005 Option Period 1 CLIN Detail Attachment J.12

&P of &N

Option Period 2 CLIN Detail

CLIN	Description	PWS Deliverable #	PWS Deliverable Name		Billable Milestone Amount
0201	Project Management Services	8	Project Status Reports
		9	Analyses and Presentations
		10	EVM Analyses, Forecasts and Performance Reports
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Project Management Activities		12	MO	0
Subtotal							0

0202	EDW and Reporting Capability	53	Updated High Level Operational Reporting Strategy and Recommendations
		56	Updated Operationsl Reports Requirements Documents
		59	Updated/Additional Operational Reports High Level Designs
		62	Updated/Additional Operational Reports Detailed Designs
		64	Final Operational Reports Code
		65	Updated/Additional Operational Reports Code
		67	Final Operational Reports Test Plan
		68	Updated Operational Reports Test Plan
		69	Draft Operational Reports Test Results
		70	Final Operaional Reports Test Results
		71	Updated Operational Reports Test Results
		74	Updated Operational Reports Training Plan
		77	Updated Operational Reports Deployment Plan
		84	Updated EDW Requirements Document
		87	Updated EDW Architecture Detailed Design Document
		90	Updated Required Data Transfer Documentation
		93	Updated EDW/BI Implementation Approach
		95	Final EDW Solution and Underlying Code Delivery
		96	Updted/Additional EDW Solution and Underlying Code Delivery
		99	Updated EDW Training Plan
		102	Updated EDW Deployment Plan
		105	Updated/Additional Reporting/BI Detailed Level Designs
		108	Updated/Additional Reporting/BI High Level Designs
		111	Updated/Additional Reporting/BI Detailed Level Designs
		112	Initial Reporting/BI Solution and Underlying Code Delivery
		113	Final Reporting/BI Solution and Underlying Code Delivery
		114	Updated/Additional Reporting/BI Solution and Underlying Code Delivery
		117	Updated Operational Reports Training Plan
		119	Final Reporting/BI Deployment Plan
		120	Updated Reporting/BI Deployment Plan
		123	Updated EDW Test Plan
		126	Updated Reporting/BI Test Plan
		127	Draft EDW Test Results
		128	Final EDW Test Results
		129	Updated EDW Test Results
		130	Draft Reporting/BI Test Results
		131	Final Reporting/BI Test Results
		132	Updated Reporting/BI Test Results
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required EDW and Reporting Activities		12	MO	0
Subtotal							0

0203	Phase 1 Implementation (NOAA), Part 3 and Deploy	41	Updated BAS SOPs
		44	Updated Fit/Gap Analysis
		47	Updated Solution Design Document
		49	Final Functional Concept of Operations
		50	Updated Functional Concept of Operations
		135	Updated Detailed Interface Strategy
		138	Updated Interface Requirements Documents
		141	Updated/Additional Interface High Level Designs
		144	Updated/Additional Interface Detailed Level Designs
		146	Final Interface Code for each Interface
		147	Updated/Additional Interface Code for each Interface
		150	Updated Interface Test Plan
		151	Draft interface Test Results
		152	Final Interface Test Results
		153	Updated Interface Test Results
		155	Final Interface SOPs
		156	Updated Interface SOPs
		159	Updated Interface Testing Plan
		161	Final Interface Deployment Plan
		162	Updated Interface Deployment Plan
		165	Updated Detailed Conversion Strategy (Transaction Cutover)
		167	Final Detailed Legacy System Decommissioning Strategy
		168	Updated Detailed Legacy System Decommissioning Strategy
		171	Updated Interface Requirements Documents
		174	Updated/Additional Conversion High Level Designs
		176	Final Conversion Detailed Level Designs
		177	Updated/Additional Conversion Detailed Level Designs
		179	Final Conversion Code
		180	Updated/Additional Conversion Code
		183	Updated Conversion Test Plan
		184	Draft Mock 1 Conversion Test Results
		185	Final Mock 1 Conversion Test Results
		186	Draft Mock 2 Conversion Test Results
		187	Final Mock 2 Conversion Test Results
		188	Draft Mock 3 Conversion Test Results
		189	Final Mock 3 Conversion Test Results
		192	Updated Conversion Deployment Plan
		195	Application Suite Updated Requirements (per application)
		198	Updated Detailed Application Suite System Configuration Documentation
		201	Application Suite Updated Test Plan
		202	Application Suite Draft Test Results
		203	Application Suite Final Test Results
		204	Application Suite Updated Test Results
		207	Updated Implementation Plan
		208	Updated RTM
		211	Final Go Live Plan
		212	Updated Go Live Plan
		213	Go Live Support
		216	Updated Overall Test Strategy
		219	Updated Overall Test Plan
		221	Final Test Scripts
		222	Updated Test Scripts
		223	Draft Test Analysis Report
		224	Final Test Analysis Report
		225	Updated Test Analysis Reports
		228	Updated Organizational Change Management Plan
		231	Updated Impact Assessment
		235	Updated Stakeholder Management Plan
		238	Updated Implementation Communications Plan
		244	Updated Training Curriculum and Materials
		245	Training Evaluation Report and Surveys
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 1 Implementation Activities		12	MO	0
Subtotal							0

0204	Phase 2 Implementation (NIST), Part 1	50	Updated Functional Concept of Operations
		135	Updated Detailed Interface Strategy
		138	Updated Interface Requirements Documents
		141	Updated/Additional Interface High Level Designs
		144	Updated/Additional Interface Detailed Level Designs
		147	Updated/Additional Interface Code for each Interface
		150	Updated Interface Test Plan
		156	Updated Interface SOPs
		159	Updated Interface Training Plan
		162	Updated Interface Deployment Plan
		165	Updated Detailed Conversion Strategy (Transaction Cutover)
		168	Updated Detailed Legacy Systesm Decommissioning Strategy
		171	Updated Interface Requirements Documents
		174	Updated/Additional Conversion High Level Designs
		201	Application Suite Updated Test Plan
		207	Updated Implementation Plan
		208	Updated RTM
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 1 Implementation Activities		12	MO	0
Subtotal							0

0205	O&M Services - NOAA	213	Go Live Support
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required O&M Service Activities		12	MO	0
Subtotal							0

0206	Hosting	259	Updated Data Archiving Strategy
		262	Updated Archiving Requirements
		265	Updated Archiving Design
		266	Initial Archiving Code
		267	Final Archiving Code
		268	Updated/Additional Archiving Code
		271	Updated Archiving Test Plan
		272	Draft Archiving Test Results
		273	Final Archiving Test Results
		274	Updated Archiving Test Results
		276	Final Archiving SOPs
		277	Updated Archiving SOPs
		280	Updated Archiving Training Plan
		283	Updated Archiving Deployment Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Hosting Activities (reference data from "Hosting Worksheet Base & OY 1-4" Tab)		12	MO	0	0
Subtotal							0

Total 0

1331L519R13OS0005 Option Period 2 CLIN Detail Attachment J.12

&P of &N

Option Period 3 CLIN Detail

CLIN	Description	PWS Deliverable #	PWS Deliverable Name		Billable Milestone Amount
0301	Project Management Services	8	Project Status Reports
		9	Analyses and Presentations
		10	EVM Analyses, Forecasts and Performance Reports
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Project Management Activities		12	MO	0
Subtotal							0

0302	EDW and Reporting Capability	56	Updated Operationsl Reports Requirements Documents
		59	Updated/Additional Operational Reports High Level Designs
		62	Updated/Additional Operational Reports Detailed Designs
		65	Updated/Additional Operational Reports Code
		68	Updated Operational Reports Test Plan
		71	Updated Operational Reports Test Results
		74	Updated Operational Reports Training Plan
		96	Updated/Additional EDW Solution and Underlying Code Delivery
		114	Updated/Additional Reporting/BI Solution and Underlying Code Delivery
		120	Updated Reporting/BI Deployment Plan
		129	Updated EDW Test Results
		132	Updated Reporting/BI Test Results
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required EDW and Reporting Activities		12	MO	0
Subtotal							0

0303	Phase 2 Implementation (NIST), Part 2 and Deploy	153	Updated Interface Test Results
		177	Updated/Additional Conversion Detailed Level Designs
		180	Updated/Additional Conversion Code
		183	Updated Conversion Test Plan
		186	Draft Mock 2 Conversion Test Results
		189	Final Mock 3 Conversion Test Results
		192	Updated Conversion Deployment Plan
		204	Application Suite Updated Test Results
		212	Updated Go Live Plan
		213	Go Live Support
		216	Updated Overall Test Strategy
		219	Updated Overall Test Plan
		222	Updated Test Scripts
		225	Updated Test Analysis Reports
		244	Updated Training Curriculum and Materials
		245	Training Evaluation Report and Surveys
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 2 Implementation Activities		12	MO	0
Subtotal							0

0304	O&M Services - NIST	213	Go Live Support
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required O&M Service Activities		12	MO	0
Subtotal							0

0305	Phase 3 Implementation (Census), Part 1	50	Updated Functional Concept of Operations
		135	Updated Detailed Interface Strategy
		138	Updated Interface Requirements Documents
		141	Updated/Additional Interface High Level Designs
		144	Updated/Additional Interface Detailed Level Designs
		147	Updated/Additional Interface Code for each Interface
		150	Updated Interface Test Plan
		156	Updated Interface SOPs
		159	Updated Interface Training Plan
		162	Updated Interface Deployment Plan
		165	Updated Detailed Conversion Strategy (Transaction Cutover)
		168	Updated Detailed Legacy Systesm Decommissioning Strategy
		171	Updated Interface Requirements Documents
		174	Updated/Additional Conversion High Level Designs
		201	Application Suite Updated Test Plan
		207	Updated Implementation Plan
		208	Updated RTM
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 3 Implementation Activities		12	MO	0
Subtotal							0

0306	O&M Services - NOAA	213	Go Live Support
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required O&M Service Activities		12	MO	0
Subtotal							0

0307	Hosting	259	Updated Data Archiving Strategy
		268	Updated/Additional Archiving Code
		274	Updated Archiving Test Results
		277	Updated Archiving SOPs
		280	Updated Archiving Training Plan
		283	Updated Archiving Deployment Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Hosting Activities (reference data from "Hosting Worksheet Base & OY 1-4" Tab)		12	MO	0	0
Subtotal							0

Total 0

1331L519R13OS0005 Option Period 3 CLIN Detail Attachment J.12

&P of &N

Option Period 4 CLIN Detail

CLIN	Description	PWS Deliverable #	PWS Deliverable Name		Billable Milestone Amount
0401	Project Management Services	8	Project Status Reports
		9	Analyses and Presentations
		10	EVM Analyses, Forecasts and Performance Reports
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Project Management Activities		12	MO	0
Subtotal							0

0402	EDW and Reporting Capability	56	Updated Operationsl Reports Requirements Documents
		59	Updated/Additional Operational Reports High Level Designs
		62	Updated/Additional Operational Reports Detailed Designs
		65	Updated/Additional Operational Reports Code
		68	Updated Operational Reports Test Plan
		71	Updated Operational Reports Test Results
		74	Updated Operational Reports Training Plan
		96	Updated/Additional EDW Solution and Underlying Code Delivery
		114	Updated/Additional Reporting/BI Solution and Underlying Code Delivery
		120	Updated Reporting/BI Deployment Plan
		129	Updated EDW Test Results
		132	Updated Reporting/BI Test Results
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required EDW and Reporting Activities		12	MO	0
Subtotal							0

0403	Phase 2 Implementation (Census), Part 2 and Deploy	153	Updated Interface Test Results
		177	Updated/Additional Conversion Detailed Level Designs
		180	Updated/Additional Conversion Code
		183	Updated Conversion Test Plan
		186	Draft Mock 2 Conversion Test Results
		189	Final Mock 3 Conversion Test Results
		192	Updated Conversion Deployment Plan
		204	Application Suite Updated Test Results
		212	Updated Go Live Plan
		213	Go Live Support
		216	Updated Overall Test Strategy
		219	Updated Overall Test Plan
		222	Updated Test Scripts
		225	Updated Test Analysis Reports
		244	Updated Training Curriculum and Materials
		245	Training Evaluation Report and Surveys
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Phase 2 Implementation Activities		12	MO	0
Subtotal							0

0404	O&M Services - Census	213	Go Live Support
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required O&M Service Activities		12	MO	0
Subtotal							0

0405 O&M Services - NOAA and NIST All Required O&M Service Activities (Steady State O&M - Go Live Deliverables/Support Not Applicable) 12 MO 0

0406	Hosting	259	Updated Data Archiving Strategy
		268	Updated/Additional Archiving Code
		274	Updated Archiving Test Results
		277	Updated Archiving SOPs
		280	Updated Archiving Training Plan
		283	Updated Archiving Deployment Plan
		Supplies/Services		Quantity	Unit	Unit Price	Amount
		All Other Required Hosting Activities (reference data from "Hosting Worksheet Base & OY 1-4" Tab)		12	MO	0	0
Subtotal							0

Total 0

1331L519R13OS0005 Option Period 4 CLIN Detail Attachment J.12

&P of &N

Hosting Worksheet Base & OPs1-4

CLIN	Description	Period of Performance	Cost Category	Amount
0004	Hosting (All other required hosting activities)	4/1/20 - 3/31/21	Licenses (Implementation Phase)
			Hardware/Infrastructure Design/Test/Deploy
			Networking Design/Test/Deploy
			Access Management Design/Test/Deploy
			Environment Test/Deploy (Test, Train Production)
Subtotal				0
0104	Hosting (All other required hosting activities)	4/1/21 - 3/31/22	Licenses (Implementation Phase)
			Hardware/Infrastructure Design/Test/Deploy
			Networking Design/Test/Deploy
			Access Management Design/Test/Deploy
			Environment Test/Deploy (Test, Train Production)
Subtotal				0
0206	Hosting (All other required hosting activities)	4/1/22 - 3/31/23	Licenses (Implementation Phase)
			Hardware/Infrastructure Design/Test/Deploy
			Networking Design/Test/Deploy
			Access Management Design/Test/Deploy
			Environment Test/Deploy (Test, Train Production)
Subtotal				0
0307	Hosting (All other required hosting activities)	4/1/23 - 3/31/24	Licenses (Implementation Phase)
			Hardware/Infrastructure Design/Test/Deploy
			Networking Design/Test/Deploy
			Access Management Design/Test/Deploy
			Environment Test/Deploy (Test, Train Production)
Subtotal				0
0406	Hosting (All other required hosting activities)	4/1/24 - 3/31/25	Licenses (Implementation Phase)
			Hardware/Infrastructure Design/Test/Deploy
			Networking Design/Test/Deploy
			Access Management Design/Test/Deploy
			Environment Test/Deploy (Test, Train Production)
Subtotal				0

Total 0

1331L519R13OS0005 Hosting Worksheet Base & Option Periods 1-4 Attachment J.12

&P of &N

Hosting Worksheet OPs5-19 Component/Module(s) Subscription/Traditional Metric Unit Price Quantity Price

Hosting/Infrastructure

Public Cloud Services:

Number of environments (test, dev, pre-prod, prod)

Number of Virtual Machines by size (small, med, large)

Storage (production & Backup)

Primary and secondary zones

On-premise or private cloud:
Number of environments (test, dev, pre-prod, prod)
Number of virtual CPUs
Memory
Storage (production, backup)
Primary and Secondary sites (DR, HA)
Subtotal	0

Note: Please include assumptions around following areas that impacts estimate/price above, including but not limited to:

Disaster Recovery - Recovery Time

Disaster Recovery - Recovery Point

Security - FISMA Rating/Compliance

Security - Host & Network Based Intrusion Detection

Backup & Recovery

Support for installation of application patches and service packs

Establishment and maintenance of application security and access controls for all environments.

Rigorous change control process that enforces consistent configuration management across all increments, instances, and upgrades of software

Software Licenses

S/W Licensing - Financial System

S/W Licensing - Procurement System

S/W Licensing - Property System

S/W Licensing - EDW

Subtotal 0

Full Scale, Steady State Annual Estimate for First Year of Hosting O&M Services under CLIN 0501 0

CLIN / Description	Period of Performance	Quantity	Unit	Unit Price	Amount
0501 / Hosting O&M Services	4/1/25 - 3/31/26	12	MO	0	0
0601 / Hosting O&M Services	4/1/26 - 3/31/27	12	MO	0

Author: Firm Fixed Pricing proposed for CLINs 0601 - 1901 may increase or decrease from the price proposed for CLIN 0501 consistent with the offeror's approach to delivering hosting and O&M services over the life of the contract.

Increases and/or decreases in pricing across CLINs 0601 - 1901 shall be addressed in the offeror's Basis of Estimate.

0701 / Hosting O&M Services	4/1/27 - 3/31/28	12	MO	0
0801 / Hosting O&M Services	4/1/28 - 3/31/29	12	MO	0
0901 / Hosting O&M Services	4/1/29 - 3/31/30	12	MO	0
1001 / Hosting O&M Services	4/1/30 - 3/31/31	12	MO	0
1101 / Hosting O&M Services	4/1/31 - 3/31/32	12	MO	0
1201 / Hosting O&M Services	4/1/32 - 3/31/33	12	MO	0
1301 / Hosting O&M Services	4/1/33 - 3/31/34	12	MO	0
1401 / Hosting O&M Services	4/1/34 - 3/31/35	12	MO	0
1501 / Hosting O&M Services	4/1/35 - 3/31/36	12	MO	0
1601 / Hosting O&M Services	4/1/36 - 3/31/37	12	MO	0
1701 / Hosting O&M Services	4/1/37 - 3/31/38	12	MO	0
1801 / Hosting O&M Services	4/1/38 - 3/31/39	12	MO	0
1901 / Hosting O&M Services	4/1/39 - 3/31/40	12	MO	0
Total Hosting O&M Services Price (CLINs 0501 - 1901)					0

1331L519R13OS005 Hosting Worksheet Option Periods 5-19 Attachment J.12

&P of &N

Labor Hour Worksheet

Labor Category

Base Period

OY1

OY2

OY3

OY4

OY5

OY6

OY7

OY8

OY9

OY10

OY11

OY12

OY13

OY14

OY15

OY16

OY17

OY18

OY19

Project Manager

Project Analyst I

Technical Manager I

Technical Consultant I

Technical Developers I

Technical Manager II

Technical Analyst I

Technical Manager III

Technical Analyst II

Technical Consultants II

Technical Analyst III

Project Analyst II

1331L519R13OS0005 Labor Hour Worksheet Attachment J.12

&P of &N

Microsoft_Word_Document.docx Attachment J.12 Instructions

1) Attachment J.12, Price Schedule, is a spreadsheet that consists of the following tabs:

· Summary Level Pricing

· Base Period CLIN Detail

· Option Period 1 CLIN Detail

· Option Period 2 CLIN Detail

· Option Period 3 CLIN Detail

· Option Period 4 CLIN Detail

· Hosting Worksheet Base & Option Periods 1 – 4

· Hosting Worksheet Option Periods 5 – 19

· Labor Hour Worksheet

2) To facilitate completion of the Price Schedule the spreadsheet contains formulas to calculate subtotals and totals and to link related information between tabs. The offeror bears exclusive responsibility, however, for ensuring that the spreadsheet is properly populated with their pricing information, and for verifying and validating the completeness and accuracy of all information including all formulas. Any omissions or errors in the Price Schedule as submitted with the offeror’s proposal are the offeror’s exclusive responsibility.

3) The CLINs for NOAA and NIST implementation and deployment also encompass implementation and deployment requirements for the bureaus that NOAA and NIST cross service. The bureaus that NOAA and NIST cross service are identified in Section 2.2 of the BAS Performance Work Statement. Census does not have any cross-servicing clients.

4) Instructions by Tab

a. Summary Level Pricing Tab

i. This tab consists of the Firm Fixed Price (FFP) CLINs applicable to the Base and Option Periods and placeholder CLINs for the optional T&M support over the life of the contract.

ii. In this tab offerors shall identify the FFP proposed by CLIN.

iii. No pricing information shall be identified for the T&M CLINs on this tab. A ceiling price for the optional T&M CLINs will be established by the Government at the time of award.

b. CLIN Detail Tabs

i. The Base Period, Option Period 1, Option Period 2, Option Period 3, and Option Period 4 CLIN Detail tabs consist of the list of deliverables and supplies/services required by CLIN.

ii. In this tab offerors shall identify the proposed billable milestone amounts for each deliverable and the proposed monthly price for all other required activities by CLIN.

iii. The billable milestone amounts represent the payment the contractor would receive after Government inspection and acceptance of the corresponding deliverable. The monthly price represents the payment the contractor would receive on a monthly basis after Government inspection and acceptance of all other required activities by CLIN.

c. Hosting Worksheet Base & Option Periods 1 – 4

i. This tab consists of pricing for all other required Hosting Activities over the Base and Option Periods 1 – 4, other than for the Hosting deliverables specified in the CLIN Detail tabs.

ii. Offerors shall identify their proposed price breakdown for all other required Hosting Activities across the 5 price elements as identified below:

1. Licenses

2. Hardware/Infrastructure Design/Test/Deploy

3. Networking Design/Test/Deploy

4. Access Management Design/Test/Deploy

5. Environment Test/Deploy (Test, Train Production)

iii. Offerors may include additional tabs or provide separate spreadsheets containing further details regarding the calculation of these price elements.

d. Hosting Worksheet Option Periods 5 – 19

i. This tab consists of pricing for all hosting activities required for full scale, steady state operations over Option Periods 5 – 19.

ii. Offerors shall provide a detailed Basis of Estimate (BOE) for hosting service by hosting environment including solution assumptions related to pricing.

iii. If proposing a SaaS component, the BOE must detail the measure of SaaS units required to deliver the solution.

iv. In this tab offerors shall identify the total proposed FFP for hosting on an annual basis, payable on a monthly basis in 12 equal payments.

e. Labor Hour Worksheet

i. This tab consists of the fully burdened, hourly labor rates applicable to Labor Categories who may perform work on a Labor Hour basis under the contract.

ii. Offerors shall insert their proposed fully burdened, hourly labor rate for the Base Period and Option Periods 1 – 19 for each Labor Category.

iii. The hourly rates proposed will be incorporated into the resulting contract and will be binding on work performed on a Labor Hour basis over the life of the contract.

image1.emf

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