Copy of Att 2 Cost Response Worksheet.xlsx

XLSX spreadsheet 71 KB Posted Feb 4, 2022

Attached to: 22EHSLCe-CASRFR: Request for Responses for the EHS Comprehensive Assessment System Vendor
Solicitation number: BD-22-1039-EHS01-EHS01-70914
Issued by: Suffolk County, Massachusetts

About this file

Written by GovTribe AI · Aug 1, 2024

This document is a cost response worksheet for a request for responses (RFR) issued by the Executive Office of Health and Human Services (EOHHS) in Massachusetts for an electronic Comprehensive Assessment System (e-CAS) software solution. The RFR seeks to procure a qualified vendor to implement, maintain, and support the e-CAS solution for certain MassHealth long-term services and supports and behavioral health programs, with potential expansion to other MassHealth programs.

The cost response worksheet covers various cost components, including software acquisition and right-to-use fees, implementation costs for two phases, maintenance and operations support services, and mailing services. Bidders are required to provide detailed cost estimates for each component over an 8-year contract period. The RFR also includes specific requirements and timelines for the implementation and maintenance of the e-CAS solution.

View the file

Other files

File	Type	Posted
Att 1a Appendix B to DMCA Final Enterprise Standards.pdf	PDF	Feb 4, 2022
Att 5 Key Performance Indicators.docx	DOCX document	Feb 4, 2022
Att 7 MassHealth LTSS Programs.docx	DOCX document	Feb 4, 2022
Att 8 UCA Specific Program Assessment Process Flows.docx	DOCX document	Feb 4, 2022
Copy of Att 6 Requirements Matrix.xlsx	XLSX spreadsheet	Feb 4, 2022
e CAS Vendor RFR Questions and Answers.docx	DOCX document	Feb 4, 2022
Amendment 1 to the e CAS Vendor RFR~1.docx	DOCX document	Feb 4, 2022
Amendment 3 to the e CAS Vendor RFR~1.docx	DOCX document	Feb 4, 2022
Att 10 System Support Matrix added by RFR Amendment 3.xlsx	XLSX spreadsheet	Feb 4, 2022
Att 3 eCAS Reports and Plans~1.docx	DOCX document	Feb 4, 2022
Att 4 Secretariat Application Reference Manual 3.6 replaced by RFR Amendment 3.pdf	PDF	Feb 4, 2022
e CAS Vendor RFR Required Forms_1.zip	ZIP file	Feb 4, 2022
eCAS Vendor RFR~1.docx	DOCX document	Feb 4, 2022
Amendment 2 to the e CAS Vendor RFR.docx	DOCX document	Feb 4, 2022
Att 1 Template Statement of Work.docx	DOCX document	Feb 4, 2022
Att 11 e CAS Conceptual Architecture Diagram added by RFR Amendment 3.pdf	PDF	Feb 4, 2022
IntentToPost e CAS RFR WTO Notice.docx	DOCX document	Feb 4, 2022
RFR Att 9 Mandatory Response Forms Checklist and Acknowledgements~1.docx	DOCX document	Feb 4, 2022

Show all 18

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.

Cover Sheet

BIDDER NAME:

Attachment 2 - Cost Response Worksheet

Instructions The Bidder must submit a cost response in accordance with the instructions presented in this Attachment 2. EOHHS requires that the attached price tables be completed as they are presented. Failure to complete the price tables may disqualify the Bidder’s proposal. All assumptions or constraints made in arriving at the prices proposed in these price tables must be clearly described. Bidders are encouraged to include narrative to describe the assumptions on which this price response is based.

CONTENTS/HIGH-LEVEL INSTRUCTIONS

Schedule 1. Cost Rollup by Category - Complete Change Requests Bank of Hours, Confirm total costs

Schedule 2. Software Acquisition and Right to Use - Complete in full following the instructions on the bottom of the tab

Schedule 3a. Implementation Phase 1 - Complete in full following the instructions on the bottom of the tab

Schedule 3b. Implementation Phase 2 - Complete in full following the instructions on the bottom of the tab

Schedule 4. Maintenance and Support - Complete in full following the instructions on the bottom of the tab

Schedule 5. Mail Management Services - Complete in full following the instructions on the bottom of the tab

0.1 Cost Summary

Schedule 0.1. UCA System Solution Costs - Consolidated HIDE HIDE

COST SUMMARY Table will be populated from information in other schedules.	COST SUMMARY Table will be populated from information in other schedules
Scenario #1: IMPLEMENTATION WITH IAE (Referral and Scheduling Modules)	Scenario #2: IMPLEMENTATION WITH PROVIDERS (Provider Referral Module)

HIDE	1	2	3	4	5	6	7	8		Discount rate:	1.03	HIDE	1	2	3	4	5	6	7	8
	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	YEAR 6	YEAR 7	YEAR 8	CONTRACT PERIOD TOTAL COST				YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	YEAR 6	YEAR 7	YEAR 8	CONTRACT PERIOD TOTAL COST

ONE-TIME/NON-RECURRING COSTS:

ERROR:#REF!

ANNUALLY RECURRING COSTS:

ERROR:#REF!

TOTALS $ - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! TOTALS $ - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Scenario #1 SUMMARIZED EXPLANATION OF COSTS	Scenario #2 SUMMARIZED EXPLANATION OF COSTS
One-time/non-recurring costs:	One-time/non-recurring costs:

Annually recurring costs: Annually recurring costs:

1. Cost Rollup by Category Schedule 0.2. UCA System Solution Costs - Rollup by Category - Scenarios 1 & 2

Scenario #1: IMPLEMENTATION WITH IAE (Referral and Scheduling Modules)

COST CATEGORIES: YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 CONTRACT PERIOD TOTAL COST BIDDER NOTES

Software Acquisition and Right to Use (Schedule 1): ERROR:#REF! $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 ERROR:#REF! $ - 0

Implementation Tasks (Schedules 3a & 3b)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Phase 1		$ - 0					$ - 0
Phase 2		$ - 0	$ - 0				$ - 0

Maintenance and Support Tasks (Schedule 4): $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Change Requests bank of 1,200 hours per year (average of 100 per month; refer to time and materials services in Attachment 1, SOW Template, Section 9.3.2) for development, testing and implementation of application changes/modifications - including but not limited to future interfaces, forms and reports - which are outside of the scope of application maintenance or application support, and the management thereof $ - 0

TOTALS ERROR:#REF! $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

2. SW Acq and Right to Use Schedule 1. Software Acquisition and Right to Use - Scenarios 1 and 2 (See Instructions below)

ONE-TIME/NON-RECURRING CHARGES/FEES

	Product	Product Description/Module	Type
(Software license, acquisition fee, activation fee, etc.)	Unit
(# individual users, # concurrent users, # sites, enterprise, each, etc.)	Charge/
Fee per Unit				# UNITS YEAR 1	# UNITS YEAR 2	# UNITS YEAR 3	# UNITS YEAR 4	# UNITS YEAR 5	COST
YEAR 1	COST
YEAR 2	COST
YEAR 3	COST
YEAR 4	COST
YEAR 5								TOTAL CONTRACT PERIOD COST		BIDDER NOTES
														$ - 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
														$ - 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
														$ - 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
														$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUBTOTAL (Non-Recurring Charges/Fees)						- 0	$ - 0	0	0	0	0	0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

RECURRING CHARGES/FEES

	Product	Product Description/Module	Type	Unit	Charge/
Fee per Unit				# UNITS YEAR 1	# UNITS YEAR 2	# UNITS YEAR 3	# UNITS YEAR 4	# UNITS YEAR 5	COST
YEAR 1	COST
YEAR 2	COST
YEAR 3	COST
YEAR 4	COST
YEAR 5								TOTAL CONTRACT PERIOD COST		BIDDER NOTES
														$ - 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
														$ - 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
														$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
														$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	SUBTOTAL (Recurring Charges/Fees)								- 0	- 0	- 0	- 0	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

TOTAL (All Non-Recurring & Recurring Charges/Fees) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

EXPLANATION OF COSTS

One-time/non-recurring:

Recurring:

Instructions:

The information provided by the Bidder in this tab should reflect costs for Software Acquisition and Right to Use for building the e-CAS.

Costs for Software Acquisition and Right to Use should reflect costs associated with fulfillment of requirements in Sections 1.4 and 3.1, 3.2, 3.3 and 3.4 of the RFR and any associated Attachment 6 requirements. Bidders are also asked to provide estimates of Charges/Fees per Unit at contract execution for each year. Please add notes to explain the information and add additional rows, as needed.

3a. Implementation Phase 1 Schedule 3a. e-CAS Implementation Costs - Phase 1

Refer to RFR Sections 3.1 and 3.2	Refer to RFR Sections 3.1 and 3.2
ORGANIZATION:

LABOR COSTS

					Hours by Project Task
					Please see RFR Section 3.6 for Phase1 timeline. Estimates should include total hours by project task for the complete implementation of Phase 1
#	Resource Name	Organization	Role	Resource Hourly Rate	Project Initiation, Requirements Gathering, Customization and/or Configuration, Testing, and Deployment	Data Interfaces and Trading Partner Testing	Pilot	User Training and Knowledge Transfer	Project Management	TOTAL HOURS	TOTAL RESOURCE COST	Bidder Notes
	May be TBD	May be Vendor or subcontractor	Examples: Project Manager, Business Analyst, Developer	Rates must be "fully loaded", i.e. they must build in all costs associated with a labor resource including allocated overhead; Rate is agreed upon for Contract duration	Includes activities defined in RFR Sections 3.2.1, 3.2.2, 3.2.3, 3.2.4, 3.2.7, 3.2.8	Includes activities defined in RFR Section 3.2.3	Includes activities defined in RFR Section 3.2.5	Includes activities defined in RFR Section 3.2.6	Includes Project Management and account management (ex. Vendor leadership staff) to support all activities in RFR Section 3.2
1										- 0	$ - 0
2										- 0	$ - 0
3										- 0	$ - 0
4										- 0	$ - 0
5										- 0	$ - 0
6										- 0	$ - 0
7										- 0	$ - 0
8										- 0	$ - 0
9										- 0	$ - 0
10										- 0	$ - 0
11										- 0	$ - 0
12										- 0	$ - 0
TOTAL LABOR COSTS:										- 0	$ - 0

NON-LABOR COSTS

Explanation of Non-Labor Costs Total Non-Labor Costs $ - 0

IMPLEMENTATION COSTS GRAND TOTAL: $ - 0

3b. Implementation Phase 2 Schedule 3a. e-CAS Implementation Costs - Phase 2

Refer to RFR Sections 3.1 and 3.2	Refer to RFR Sections 3.1 and 3.2
ORGANIZATION:

LABOR COSTS

					Hours by Project Task
					Please see RFR Section 3.6 for Phase 2 timeline. Estimates should include total hours by project task for the complete implementation of Phase 2
#	Resource Name	Organization	Role	Resource Hourly Rate	Project Initiation, Requirements Gathering, Customization and/or Configuration, Testing, and Deployment	Data Interfaces and Trading Partner Testing	Pilot	User Training and Knowledge Transfer	Project Management	TOTAL HOURS	TOTAL RESOURCE COST	Bidder Notes
	May be TBD	May be Vendor or subcontractor	Examples: Project Manager, Business Analyst, Developer	Rates must be "fully loaded", i.e. they must build in all costs associated with a labor resource including allocated overhead; Rate is agreed upon for Contract duration	Includes activities defined in RFR Sections 3.2.1, 3.2.2, 3.2.3, 3.2.4, 3.2.7, 3.2.8	Includes activities defined in RFR Section 3.2.3	Includes activities defined in RFR Section 3.2.5	Includes activities defined in RFR Section 3.2.6	Includes Project Management and account management (ex. Vendor leadership staff) to support all activities in RFR Section 3.2
1										- 0	$ - 0
2										- 0	$ - 0
3										- 0	$ - 0
4										- 0	$ - 0
5										- 0	$ - 0
6										- 0	$ - 0
7										- 0	$ - 0
8										- 0	$ - 0
9										- 0	$ - 0
10										- 0	$ - 0
11										- 0	$ - 0
12										- 0	$ - 0
TOTAL LABOR COSTS:					- 0	- 0	- 0	- 0	- 0	- 0	$ - 0

NON-LABOR COSTS

Explanation of Non-Labor Costs Total Non-Labor Costs $ - 0

IMPLEMENTATION COSTS GRAND TOTAL: $ - 0

4. Maint and Support Schedule 4. UCA System Maintenance and Operations Support Services Costs

Labor Costs
MAINTENANCE AND OPERATIONS SUPPORT SUBTASK:		Resource Name	Organization	Role	Resource Hourly Rate	YEAR 1 HOURS				YEAR 2 HOURS				YEAR 3 HOURS				YEAR 4 HOURS				YEAR 5 HOURS				LABOR COSTS SUBTOTALS
	#	May be TBD	May be Vendor or subcontractor	Examples: Project Manager, Business Analyst, Developer	Rates must be "fully loaded", i.e. they must build in all costs associated with a labor resource including allocated overhead; Rate is agreed upon for Contract duration	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Year 1	Year 2	Year 3	Year 4	Year 5	All Years
System Maintenance as defined in Section 3.3.1	1																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	2																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	3																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	4																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	5																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System Operations as defined in Section 3.3.2	6																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	7																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	8																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	9																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	10																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System Security Administration as defined in Section 3.3.3	11																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	12																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	13																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	14																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	15																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System End User Support as defined in Section 3.3.4	16																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	17																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	18																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	19																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	20																									$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
LABOR COSTS SUBTOTAL																										$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Refer to RFR Sections 3.3 and 3.4 and Attachment 1 Template Statement of Work
Non-Labor Costs
MAINTENANCE AND OPERATIONS SUPPORT SUBTASK:	Summary Description of Non-Labor Costs	YEAR 1 COSTS				YEAR 2 COSTS				YEAR 3 COSTS				YEAR 4 COSTS				YEAR 5 COSTS				LABOR COSTS SUBTOTALS
		Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4	Year 1	Year 2	Year 3	Year 4	Year 5	All Years
System Maintenance as defined in Section 3.3.1																						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System Operations as defined in Section 3.3.2																						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System Security Administration as defined in Section 3.3.3																						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
System End User Support as defined in Section 3.3.4																						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NON-LABOR COSTS SUBTOTAL																						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

MAINTENANCE AND OPERATIONS COSTS GRAND TOTAL: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Instructions:

The cost information in this tab should capture costs for Maintenance and Operations Support for the UCA System using two possible scenarios.

Costs for Maintenance and Operations Support associated with the UCA System includes costs for fulfilling requirements in Section 1.4 and 3.3 and 3.4 of the RFR and any associated Attachment 6 requirements. Costs associated with each component presented in the table shall be populated by the Bidder. Bidders are also asked to provide estimates of hours required to complete each subtask. Please add notes to explain the information and add additional rows, as needed.

Scenario #1 covers assessments conducted by an Independent Assessor Entity (IAE). Key functionality unique for this scenario are referral and scheduling modules, described in Attachment 6. Scenario #2 is for assessments conducted by providers. For this scenario, a schedule module will not be in scope and a provider referral module will be included, as described in Attachment 6.

5. Mail Mgmt Services Schedule 5.UCA System Mailing Services Add On

Outbound Mailing Services Costs (see RFR Section 1.4.4.10.1)	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	SUBTOTAL
(e.g. Printing, Stuffing, Address management)

TOTAL COST	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
							SUBTOTAL
Inbound Mailing Services Costs (see RFR Section 1.4.4.10.2)	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	SUBTOTAL
(e.g. Recording metadata, digitizing, developing disposition )

TOTAL COST $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Pass-Through Cost Description	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5	SUBTOTAL
(e.g. Postage, Licensing, etc.)

TOTAL COST	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Instructions:

The cost information in this tab should capture costs for UCA System Mailing Services. All Bidders must complete this information, however EOHHS may determine that it wants the Selected Bidder to implement some or all of the services required in Section 1.4.4.10 Mail Management Services, either Outbound mailing services, including postage/shipping costs and/or Inbound mailing services.

Key Assumptions for Notices:

EOHHS expects to generate approximately 100,000 notices per year.

File details come from the government source that posted it. Updated Aug 1, 2024.