Attachment P- Cost Proposal Workbook.xlsx
XLSX spreadsheet 135 KB Posted
- Attached to
- ECONOMIC SVCS SYSTEM APP MODERNIZATION State and local contract opportunity
- Solicitation number
- 5400024945
- Issued by
- Richland County, South Carolina
About this file
This is a Cost Proposal Workbook template for the Economic Services Systems Application Modernization (ESSAM) Solution, a state and local contract opportunity issued by the State of South Carolina Department of Social Services under RFP #5400024945. The workbook serves as the formal cost proposal document for contractors responding to the ESSAM modernization initiative and requires completion of all applicable worksheets to represent costs associated with delivering the project requirements. The contract encompasses a 12-year term divided into implementation phases and ongoing maintenance and operations (M&O) support, with Design, Development, and Implementation (DDI) activities required to be completed within four years of Solution Development Center (SDC) onboarding.
The cost proposal structure requires contractors to submit hourly labor rates for multiple staff classifications across implementation, application maintenance and operations, enhancements, and help desk support functions, with labor rate escalations capped at 2% annually. Contractors must provide itemized costs for solution implementation deliverables, ongoing M&O services (with a mandated 15,000 hours annually for enhancements and modifications), help desk operations, packaged software (both existing and new), hardware, hosting services, and cloud subscription services across all 12 contract years. The workbook is designed with automated calculations that pull data from individual component worksheets into a total cost summary, and contractors must validate formula integrity and ensure all costs are fully inclusive of expenses such as licensing, delivery, installation, travel, training, and facilities. Contractors are required to document all assumptions underlying their pricing in a dedicated worksheet, with invalid assumptions that conflict with RFP requirements potentially resulting in proposal disqualification.
View the file
Other files for this state and local contract opportunity
Show all 22
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
Text version
Introduction
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Introduction |
| This Template provides a structured approach for proposing the costs associated with delivering the ESSAM requirements. The Contractor must fill out all applicable worksheets and cells as described by the Template and individual worksheet instructions. This Template is the formal Cost Proposal for the Contractor's Proposal. The Contractor warrants that all costs associated with the services as requested in this RFP are included in this Template. Failure to adequately represent all costs as requested in this RFP may be grounds for Proposal disqualification at the sole discretion of DSS and the State of South Carolina. |
Where costs are requested on an annual basis, the year refers to the appropriate year of the Contract (i.e. Year 1 refers to the first year of the Contract rather than calendar or Federal fiscal year). Contractors must complete the Cost Proposal with the expected cost rate based on the anticipated Contract start date as stated in the RFP. However, should the Contract start date shift for any reason, DSS expects Contractors to honor the costs as stated in their Cost Proposal. DSS understands that the Contract will likely begin in the middle of a fiscal or calendar year. The awarded Contract will be aligned to appropriate calendar and/or fiscal years during Contract negotiations. The total bid cost is a firm fixed price Proposal and the determination of the Contract start date will not affect the total bid price.
This workbook contains cost information required for submission of a Proposal for the ESSAM Services in this RFP. The worksheets within this Response Template are listed below. All worksheets must be completed. Any Proposals that do not provide complete cost information may be excluded from the competitive field.
> Cells requiring Contractor data entry are highlighted in light-green to clearly indicate which cells are available for data entry.
> Cells that contain titles and formulas are marked in dark blue and gray highlight.
> Cells that are not applicable are marked in black highlight.
> Do NOT add, edit or adjust cells unless specifically requested to do so.
> It is the Contractor's responsibility to validate the integrity of the Cost Workbook formulas and links.
Key Assumptions:
* Contractors must abide by the deadlines detailed in the RFP.
Instructions: Do nothing on this sheet.
| Table of Contents | ||
| ID # | Section Title | Description |
| Introduction | Cover Page, Instructions and Table of Contents | |
| 1 | Total Cost Summary | Worksheet to providing a summary of the total proposed costs. |
| 2 | Labor Rates | Worksheet for itemizing hourly rate structures for proposed project personnel. |
| 3 | Implementation | Worksheet for one-time, total solution implementation project costs. |
| 4 | Application Maintenance and Operations Support | Worksheet for Contractor to itemize application maintenance and operations costs. |
| 5 | Help Desk Support | Worksheet for Contractor to itemize Help Desk support costs. |
| 6 | Packaged Software | Worksheet for Contractor to itemize all one-time and ongoing packaged software costs. |
| 7 | Hardware | Worksheet for Contractor to itemize all one-time and ongoing hardware costs. |
| 8 | Hosting | Worksheet for Contractor to itemize all ongoing hosting costs. |
| 9 | Cloud Subscription Services | Worksheet for Contractor to itemize all one-time and ongoing Cloud Subscription Service costs. |
| 10 | Cost Assumptions | Worksheet for Contractor to detail assumptions upon which pricing is dependent. |
&"Arial,Regular"&A
&"Arial,Regular"&9&K000000&F &"Arial,Regular"&9&K000000&P of &N
1. Total Cost Summary
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Cost Summary |
| The costs on this worksheet will be automatically calculated using the information entered in the other worksheets. It is the Contractor's responsibility to ensure that costs on this sheet reflects the full Proposal cost for the services outlined in the RFP. |
Instructions: Do not edit any cells on this sheet. Prior to submission, confirm all costs reflect the Proposal cost total.
| Total Cost Summary | |
| Description | Total |
One-time Costs Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Total Ongoing Costs Total Costs
| 3. Solution Implementation | $0 | $0 | |||||||||||||
| 4. Application Maintenance and Operations Support | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 5. Help Desk | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 6. Packaged Software | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| 7. Hardware | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| 8. Hosting | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 9. Cloud Subscription Services | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total One Time and Ongoing Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
2. Labor Rates
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Labor Rates |
| The Tables in this worksheet shall be used to provide Contractor/subcontractor hourly labor rates for the various classifications and grades of personnel. |
The labor rates must be loaded costs. Applicable purchase, delivery, tax, services, safety, license, travel, per diem, Contractor’s staff training, facilities and any other expenses associated with the delivery of the proposed items and must be included in the Contractor’s costs and fixed hourly rates. Use of the existing roles is appreciated, but not required. The Contractor may include additional roles to accurately represent the classifications it uses for describing the various classifications and grades of its personnel.
The total of the Composite Weight Percentage column must equal 100%. Individual and composite hourly rates shall not increase greater than 2% per year.
It is the responsibility of the Contractor to ensure spreadsheet calculations are correct.
Instructions: Enter the staff roles, composite weight percentage, and hourly rate required for the tables below. Additional rows may be added if necessary.
| Table 1. Implementation Hourly Rates | ||||
| Staff Position | Composite Weight % (must equal 100%) | Hourly Rate | ||
| (During DDI) | Composite Rate |
(During DDI)
| Executive Staff for Project Oversight | $0 | |
| Management Staff for Project Management | $0 | |
| SMEs for Requirements Phase | $0 | |
| SMEs for Architecture and Design Phase | $0 | |
| SMEs for Development Phase | $0 | |
| SMEs for Testing Phase | $0 | |
| SMEs for Training Phase | $0 | |
| SMEs for Data Conversion and Deployment Phase | $0 | |
| Other (specify - add rows as required) | $0 | |
| Other (specify - add rows as required) | $0 | |
| Other (specify - add rows as required) | $0 | |
| Other (specify - add rows as required) | $0 | |
| Other (specify - add rows as required) | $0 | |
| Composite Rate | 0% | $0 |
| Table 2. Application Maintenance and Operations Hourly Rate | ||||
| Staff Position | Composite Weight % (must equal 100%) | Hourly Rate | ||
| Year 1 | Composite Rate | |||
| Year 1 | Hourly Rate | |||
| Year 2 | Composite Rate | |||
| Year 2 | Hourly Rate | |||
| Year 3 | Composite Rate | |||
| Year 3 | Hourly Rate | |||
| Year 4 | Composite Rate | |||
| Year 4 | Hourly Rate | |||
| Year 5 | Composite Rate | |||
| Year 5 | Hourly Rate | |||
| Year 6 | Composite Rate | |||
| Year 6 | Hourly Rate | |||
| Year 7 | Composite Rate | |||
| Year 7 | Hourly Rate | |||
| Year 8 | Composite Rate | |||
| Year 8 | Hourly Rate | |||
| Year 9 | Composite Rate | |||
| Year 9 | Hourly Rate | |||
| Year 10 | Composite Rate | |||
| Year 10 | Hourly Rate | |||
| Year 11 | Composite Rate | |||
| Year 11 | Hourly Rate | |||
| Year 12 | Composite Rate |
Year 12
| Project Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Functional Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Test Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Functional BAs/Testers | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Technical Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Technical Architect | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Developers | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Composite Rate | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| Table 3. Application Maintenance and Operations Enhancement Hourly Rates | ||||||||||||||||
| Staff Position | Composite Weight % (must equal 100%) | Hourly Rate | ||||||||||||||
| Year 1 | Composite Rate | |||||||||||||||
| Year 1 | Hourly Rate | |||||||||||||||
| Year 2 | Composite Rate | |||||||||||||||
| Year 2 | Hourly Rate | |||||||||||||||
| Year 3 | Composite Rate | |||||||||||||||
| Year 3 | Hourly Rate | |||||||||||||||
| Year 4 | Composite Rate | |||||||||||||||
| Year 4 | Hourly Rate | |||||||||||||||
| Year 5 | Composite Rate | |||||||||||||||
| Year 5 | Hourly Rate | |||||||||||||||
| Year 6 | Composite Rate | |||||||||||||||
| Year 6 | Hourly Rate | |||||||||||||||
| Year 7 | Composite Rate | |||||||||||||||
| Year 7 | Hourly Rate | |||||||||||||||
| Year 8 | Composite Rate | |||||||||||||||
| Year 8 | Hourly Rate | |||||||||||||||
| Year 9 | Composite Rate | |||||||||||||||
| Year 9 | Hourly Rate | |||||||||||||||
| Year 10 | Composite Rate | |||||||||||||||
| Year 10 | Hourly Rate | |||||||||||||||
| Year 11 | Composite Rate | |||||||||||||||
| Year 11 | Hourly Rate | |||||||||||||||
| Year 12 | Composite Rate |
Year 12
| Project Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Functional Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Test Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Functional BAs/Testers | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Technical Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Technical Architect | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Developers | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Composite Rate | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| Table 4. Help Desk Hourly Rates | ||||||||||||||||
| Staff Position | Composite Weight % (must equal 100%) | Hourly Rate | ||||||||||||||
| Year 1 | Composite Rate | |||||||||||||||
| Year 1 | Hourly Rate | |||||||||||||||
| Year 2 | Composite Rate | |||||||||||||||
| Year 2 | Hourly Rate | |||||||||||||||
| Year 3 | Composite Rate | |||||||||||||||
| Year 3 | Hourly Rate | |||||||||||||||
| Year 4 | Composite Rate | |||||||||||||||
| Year 4 | Hourly Rate | |||||||||||||||
| Year 5 | Composite Rate | |||||||||||||||
| Year 5 | Hourly Rate | |||||||||||||||
| Year 6 | Composite Rate | |||||||||||||||
| Year 6 | Hourly Rate | |||||||||||||||
| Year 7 | Composite Rate | |||||||||||||||
| Year 7 | Hourly Rate | |||||||||||||||
| Year 8 | Composite Rate | |||||||||||||||
| Year 8 | Hourly Rate | |||||||||||||||
| Year 9 | Composite Rate | |||||||||||||||
| Year 9 | Hourly Rate | |||||||||||||||
| Year 10 | Composite Rate | |||||||||||||||
| Year 10 | Hourly Rate | |||||||||||||||
| Year 11 | Composite Rate | |||||||||||||||
| Year 11 | Hourly Rate | |||||||||||||||
| Year 12 | Composite Rate |
Year 12
| Help Desk Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Tier 1 Staff | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Tier 2 Staff | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Tier 3 Staff | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other (specify - add rows as required) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Composite Rate | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
3. Implementation
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Implementation Costs |
| All tasks associated with the implementation services proposed shall be included in the total one-time cost for that service, as outlined in the RFP and associated templates. All deliverable hours and costs must accurately reflect the level of effort required to complete that deliverable. All deliverable costs are subject to approval of the content of the deliverable. DSS expects the Implementation costs to be calculated based on the appropriate composite rate. |
Design, Development, and Implementation (DDI) must be completed within 4 years of SDC onboarding. Vendors are encouraged to complete DDI as expeditiously as possible within an appropriate level of risk. The State will conduct checkpoints during the ESSAM SDLC and M&O to ensure a high quality deliverables and ESSAM solution.
It is the responsibility of the Contractor to ensure spreadsheet calculations are correct. All costs must be fully inclusive.
Instructions: Enter the hours required to complete the deliverables listed, including the number of deliverables where requested. Enter any additional tasks and deliverables as needed. Insert additional rows as necessary where noted.
| Solution Implementation | |||
| Deliverable Group | Description | Hours | Composite |
Rate for Implementation Total One-time Costs I.1 -Project Initiation, Planning, and Proposed System
| Viability Review | I.1.1 | Project Kickoff completion and Project Approach Document | $0 | $0 | |||
| I.1.2 | Project Schedule – approved by DSS | $0 | $0 | ||||
| I.1.3 | Project Management Plan – approved by DSS | $0 | $0 | ||||
| I.1.4 | Establishment of the existing commercial-off-the-shelf, transfer solution, or subscription service in a sandbox environment within ninety (90) days of the Contract Effective Date, and the demonstration to the State staff of the viability of the solution to provide the functionality requested by the State | $0 | $0 | ||||
| I.2 - Requirements | |||||||
| Validation | I.2.1 | Gap Analysis Report | $0 | $0 | |||
| I.2.2 | Requirements Definition Document | $0 | $0 | ||||
| I.2.3 | Functional and Technical Requirements Traceability Matrices | $0 | $0 | ||||
| I.2.4 | Glossary of Terms and Acronyms | $0 | $0 | ||||
| I.3 - System | |||||||
| Design | I.3.1 | General Functional System Design | $0 | $0 | |||
| I.3.2 | Architecture Design Documents | $0 | $0 | ||||
| I.3.3 | Detailed Technical System Design | $0 | $0 | ||||
| I.3.4 | Detailed Functional System Design | $0 | $0 | ||||
| I.3.5 | Disaster Recovery and Business Continuity Plan | $0 | $0 | ||||
| I.3.6 | Interface Design | $0 | $0 | ||||
| I.3.7 | Database Design, including Logical and Physical Database Design Documents | $0 | $0 | ||||
| I.3.8 | Security Plan | $0 | $0 | ||||
| I.3.9 | Risk Assessment | $0 | $0 | ||||
| I.3.10 | Contingency Plan | $0 | $0 | ||||
| I.3.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.4 - System | |||||||
| Development | I.4.1 | Source Code and Supporting Documentation (if applicable) | $0 | $0 | |||
| I.4.2 | Results of the pre-UAT Security Risk and Impact Assessment | $0 | $0 | ||||
| I.4.3 | Unit Test Results | $0 | $0 | ||||
| I.4.4 | System Development Completion | $0 | $0 | ||||
| I.4.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.5 - Data Conversion | I.5.1 | Data Conversion Plan | $0 | $0 | |||
| I.5.2 | Data Migration Documentation, including but not limited to Data Dictionary, Data Models, Data Flow Models, and Process Models | $0 | $0 | ||||
| I.5.3 | Data Conversion and Migration Test Results | $0 | $0 | ||||
| I.5.4 | Successful Data Conversion and Migration Completion | $0 | $0 | ||||
| I.5.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.6 - Testing | I.6.1 | Comprehensive Test Plan (for all testing cycles) | $0 | $0 | |||
| I.6.2 | Complete and Final Test Plan | $0 | $0 | ||||
| I.6.3 | Test Scripts (for all testing cycles except UAT) | $0 | $0 | ||||
| I.6.4 | Test Results (for all testing cycles except UAT) | $0 | $0 | ||||
| I.6.5 | Post-UAT Go/No-Go Decision Document support | $0 | $0 | ||||
| I.6.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.7 - Pilot Implementation | I.7.1 | Pilot Implementation Plan | $0 | $0 | |||
| I.7.2 | System User Account Maintenance Procedures | $0 | $0 | ||||
| I.7.3 | Pilot Implementation | $0 | $0 | ||||
| I.7.4 | Lessons Learned Report | $0 | $0 | ||||
| I.7.5 | Post- Pilot Implementation Go/No-Go Decision Document support | $0 | $0 | ||||
| I.7.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.8 - Statewide | |||||||
| Implementation | I.8.1 | Pre-Implementation Readiness Assessment | $0 | $0 | |||
| I.8.2 | Statewide Implementation Plan | $0 | $0 | ||||
| I.8.3 | Release Plan | $0 | $0 | ||||
| I.8.4 | Operations Manual | $0 | $0 | ||||
| I.8.5 | Training and Knowledge Transfer Plan | $0 | $0 | ||||
| I.8.6 | User Manual | $0 | $0 | ||||
| I.8.7 | End User Training Materials for each iteration of End User Training | $0 | $0 | ||||
| I.8.8 | End User Training Evaluation Report | $0 | $0 | ||||
| I.8.9 | Technical Staff Knowledge Transfer Materials | $0 | $0 | ||||
| I.8.10 | Technical Staff Knowledge Transfer | $0 | $0 | ||||
| I.8.11 | Technical Staff Knowledge Transfer Evaluation Report | $0 | $0 | ||||
| I.8.12 | Statewide Implementation Completion | $0 | $0 | ||||
| I.8.13 | Updated System Documentation (for State and Contractor M&O staff use) | $0 | $0 | ||||
| I.8.14 | Benefit Payment Accuracy Reports | $0 | $0 | ||||
| I.8.V | Contractor Specified Deliverable | $0 | $0 | ||||
| I.9- Warranty Support | I.9.1 | Completion of all Warranty Activities Report | No Charge | ||||
| Add additional rows/deliverables as required for Contractor's Cost Proposal | $0 | $0 | |||||
| Total Deliverables Costs | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
4. Appl M&O
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Provide M&O Services |
| The M&O costs must include all tasks and deliverables required for ongoing M&O of the ESSAM Solution, as described in the RFP and RFP Attachments. All deliverable hours and costs must accurately reflect the level of effort required to complete the tasks described in Section 3.22.2 of the RFP. All costs will be calculated based on appropriate composite rate for that year. |
For Deliverable Group O.4 - Enhancements and Modifications, Contractors must assume a level of effort representing 15,000 hours each year.
It is the responsibility of the Contractor to ensure spreadsheet calculations are correct. All costs must be fully inclusive.
| Application Maintenance and Operations Support | |||||||||||||
| Deliverable Grouping | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Total |
| Composite Rate for Application Maintenance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| O.1 – M&O Transition Planning and Services | $0 | ||||||||||||
| O.2 – Provide M&O Services, Status Reporting and Quality Assurance | $0 | ||||||||||||
| O.3 – ESSAM M&O Transition Services | $0 | ||||||||||||
| O.5 – M&O Turnover Services | $0 | ||||||||||||
| M&O Support Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Composite Rate for Application Enhancements | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| O.4 – Enhancements and Modifications | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | 180,000 |
| M&O Enhancements and Modifications Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total M&O Support Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
5. Help Desk
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Provide Help Desk Services |
| The Help Desk costs must include all tasks and deliverables required for ongoing Help Desk support of the ESSAM Solution, as described in the RFP and RFP Attachments. All hours and costs must accurately reflect the level of effort required to complete the tasks described in Section 3.22.2.6 of the RFP. All costs will be calculated based on appropriate composite rate for that year. |
It is the responsibility of the Contractor to ensure spreadsheet calculations are correct. All costs must be fully inclusive.
Instructions: Enter total number of composite hours required for each year.
| Help Desk Support | |||||||||||||
| Deliverable Grouping | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Total |
| Composite Rate for Help Desk Support | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| H.1 – Provide Help Desk Services, Reporting and Quality Assurance | 0 | ||||||||||||
| H.2 – Help Desk Turnover Services | 0 | ||||||||||||
| Internal Help Desk Support Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Composite Rate for Help Desk Support | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| H.3 – Provide Help Desk Services, Reporting and Quality Assurance | 0 | ||||||||||||
| H.4 – Help Desk Turnover Services | 0 | ||||||||||||
| External Help Desk Support Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Help Desk Support Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
6. Packaged Software
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Software |
| Contractor must leverage some of the software components already within the DSS environment and install additional software as required. The Contractor must review the information in the RFP and Attachments to determine the current inventory available. |
For existing software components already within the DSS Enterprise which the Contractor's solution will leverage the Contractor must provide anticipated maintenance costs. Note that there are no one time, acquisition costs for this software.
For any new software which the Contractor's solution will leverage the Contractor must include all one time, acquisitions, anticipated maintenance costs, and specifications (in the Package Software Specifications table).
The tables below shall list the proposed new software manufacturer, brand name, module name, and version number for the items being proposed. Costs shall include any licensing necessary to cover all environments (e.g., Development, Test, Training, Pre-Production, Production). All costs associated with the purchase, delivery, installation, inspection, licenses, and production of the Software components shall be included in the Software Cost.
Contractors may insert additional rows as required. It is the responsibility of the Contractor to ensure spreadsheet calculations are correct. New Software items in the Packaged Software Costs table must correspond to the Software Items in the Packaged Software Specifications table.
| Packaged Software Costs | ||||||||||||||||||
| Item # | Software Item | Per Unit Cost | Quantity | One Time Cost | Additional Year 1 Costs | Additional Year 2 Costs | Additional Year 3 Costs | Additional Year 4 Costs | Additional Year 5 Costs | Additional Year 6 Costs | Additional Year 7 Costs | Additional Year 8 Costs | Additional Year 9 Costs | Additional Year 10 Costs | Additional Year 11 Costs | Additional Year 12 Costs | Total Ongoing Costs | Total Item Cost |
| Existing Software Components | ||||||||||||||||||
| 1 | Item 1 | $0 | $0 | $0 | ||||||||||||||
| 2 | Item 2 | $0 | $0 | $0 | ||||||||||||||
| New Software | ||||||||||||||||||
| 1 | Item 1 | $0 | $0 | $0 | ||||||||||||||
| 2 | Item 2 | $0 | $0 | $0 | ||||||||||||||
| 3 | Item 3 | $0 | $0 | $0 | ||||||||||||||
| 4 | Item 4 | $0 | $0 | $0 | ||||||||||||||
| Total Packaged Software | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Packaged Software Specifications | ||||
| Item # | Software Item | Environment (e.g., Development, Test, Training, Production) | Manufacturer | License Type |
(e.g., enterprise, per user, per server)
| Brand Name | Module Name | Version | |||
| Number | Software Type | Detailed Description | |||
| (e.g., functionality, purpose) | Operating System | Earliest Proposed Purchase Date | |||
| 1 | Item 1 | ||||
| 2 | Item 2 | ||||
| 3 | Item 3 | ||||
| 4 | Item 4 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
7. Hardware
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Proposed Hardware |
| The Contractor must leverage the hardware already within DSS environment and install additional hardware not currently in the DSS environment to support the proposed solution. The Contractor must review the information in the RFP and Attachments to determine the current inventory available. |
For existing hardware already within the DSS environment which the Contractor's solution will leverage the Contractor must provide anticipated maintenance costs for the hardware required to support the ESSAM Solution. Note that there are no one time, acquisition costs for this hardware.
For any new hardware which the Contractor's solution will leverage the Contractor must include all one time, acquisitions, anticipated maintenance costs and specifications (in the Hardware Specifications table).
The tables below shall list the proposed new hardware manufacturer, brand name, and detailed description for the items being proposed. Costs shall include any licensing necessary to cover all environments (e.g., Development, Test, Training, Pre-Production, Production). All costs associated with the purchase, delivery, installation, inspection, and licenses of the hardware components shall be loaded into the cost.
Contractors may insert additional rows as required. It is the responsibility of the Contractor to ensure spreadsheet calculations are correct. Hardware Items in the Hardware Costs table shall correspond to the Hardware Items in the Specifications table.
| Hardware Costs | ||||||||||||||||||
| Item # | Hardware Item | Per Unit Cost | Quantity | One Time Cost | Additional Year 1 Costs | Additional Year 2 Costs | Additional Year 3 Costs | Additional Year 4 Costs | Additional Year 5 Costs | Additional Year 6 Costs | Additional Year 7 Costs | Additional Year 8 Costs | Additional Year 9 Costs | Additional Year 10 Costs | Additional Year 11 Costs | Additional Year 12 Costs | Total Ongoing Costs | Total Item Cost |
| Implementation | ||||||||||||||||||
| Existing Hardware Components | ||||||||||||||||||
| 1 | Item 1 | $0 | $0 | $0 | ||||||||||||||
| 2 | Item 2 | $0 | $0 | $0 | ||||||||||||||
| New Hardware | ||||||||||||||||||
| 1 | Item 1 | $0 | $0 | $0 | ||||||||||||||
| 2 | Item 2 | $0 | $0 | $0 | ||||||||||||||
| 3 | Item 3 | $0 | $0 | $0 | ||||||||||||||
| 4 | Item 4 | $0 | $0 | $0 | ||||||||||||||
| Total Hardware | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Hardware Specifications | |||||||
| Item # | Hardware Item | Environment (e.g., Development, Test, Training, Pre-Production, Production) | Manufacturer | Detailed Description | |||
| (e.g., number of processors, amount and type of storage and memory, type of network card, etc.) | Operating System | Earliest Proposed Purchase Date | |||||
| Implementation | |||||||
| 1 | Item 1 | ||||||
| 2 | Item 2 | ||||||
| 3 | Item 3 | ||||||
| 4 | Item 4 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
8. Hosting
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Hosting |
| If the Contractor is proposing a hosted solution, the Contractor must specify all initial solution costs in the tables below, including: monthly, quarterly, or annual costs, for the life of the contract (e.g., additional seats, transactions, storage, etc.). If the Contractor is proposing a State DTO-hosted solution that must be made clear within the assumptions provided in tab "10. Cost Assumptions." |
The table below is intended to be sufficiently flexible to meet a range of Hosted costing models. Contractors should use the "10. Cost Assumptions" tab, as appropriate, to clarify any assumptions related to their solution costing model. Contractors may insert additional rows as required. It is the responsibility of the Offeror to ensure spreadsheet calculations are correct.
| Item # | Software Item | Year 1 Costs | Year 2 Costs | Year 3 Costs | Year 4 Costs | Year 5 Costs | Year 6 Costs | Year 7 Costs | Year 8 Costs | Year 9 Costs | Year 10 Costs | Year 11 Costs | Year 12 Costs | Total Hosting Costs |
| 1 | Distributed Applications Server Hosting (physical and virtual) Costs | $0 | ||||||||||||
| 2 | Network Costs | $0 | ||||||||||||
| 3 | Storage Costs | $0 | ||||||||||||
| 4 | Disaster Recovery Costs | $0 | ||||||||||||
| 5 | Item 5 (usage volumetric assumption x annual fee) | $0 | ||||||||||||
| 6 | Item 6 | $0 | ||||||||||||
| 7 | Item 7 | $0 | ||||||||||||
| Total Annual Hosting Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Hosting Costs | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
9. Cloud Subscription Services
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Cloud Subscription Services |
| If the Contractor is proposing the use of a PaaS/SaaS solution, the Contractor must specify all initial solution costs in the tables below, including: monthly, quarterly, or annual costs, for the life of the contract (e.g., additional seats, transactions, storage, etc.) |
The table below is intended to be sufficiently flexible to meet a range of SaaS costing models. Contractors should use the "10. Cost Assumptions" tab, as appropriate, to clarify any assumptions related to their solution costing model. Contractors may insert additional rows as required. It is the responsibility of the Offeror to ensure spreadsheet calculations are correct.
| Initial Cloud Subscription Services Setup Costs | ||||||||||||||||||
| Item # | Software Item | Per Unit Cost | ||||||||||||||||
| (e.g., per user or transaction) | Quantity | One Time Cost | ||||||||||||||||
| 1 | PaaS and SaaS Services Access | $0 | ||||||||||||||||
| 2 | Item 2 | $0 | ||||||||||||||||
| 3 | Item 3 | $0 | ||||||||||||||||
| 4 | Item 4 | $0 | ||||||||||||||||
| 5 | Item 5 | $0 | ||||||||||||||||
| Initial (One Time) Costs Subtotal | $0 | |||||||||||||||||
| Ongoing Usage Costs based on Volumes | ||||||||||||||||||
| Item # | Software Item | Year 1 Costs | Year 2 Costs | Year 3 Costs | Year 4 Costs | Year 5 Costs | Year 6 Costs | Year 7 Costs | Year 8 Costs | Year 9 Costs | Year 10 Costs | Year 11 Costs | Year 12 Costs | Total Additional Item Costs | ||||
| 1 | PaaS and SaaS Services Access | $0 | ||||||||||||||||
| 2 | Item 2 (usage volumetric assumption x annual fee) | $0 | ||||||||||||||||
| 3 | Item 3 (usage volumetric assumption x annual fee) | $0 | ||||||||||||||||
| 4 | Item 4 | $0 | ||||||||||||||||
| 5 | Item 5 | $0 | ||||||||||||||||
| Total Additional Annual Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Total Cloud Subscription Services Costs | $0 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
10. Cost Assumptions
| State of South Carolina Department of Social Services |
| Economic Services Systems Application Modernization (ESSAM) Solution |
| RFP #5400024945 |
| Template C-1 - Cost Workbook |
| Cost Assumptions |
| The Contractor must state all assumptions upon which its pricing is being determined. Assumptions shall not conflict with the Terms and Conditions or Mandatory Requirements of this RFP, and shall not change the requested scope of the RFP as described in this procurement. Assumptions that conflict with the requested products/services, mandatory requirements, Terms and Conditions, or other language of the RFP or its supporting documents will be invalid and will be interpreted in favor of the RFP language. DSS may disqualify the Proposal if, in its discretion, it determines that assumptions stated here cause the Proposal to inaccurately represent the costs for scope described in the Contractor's Proposal, or meet the needs as described in this RFP. The Contractor must provide a clear understanding to DSS of the cost impact to DSS if any assumption is determined to be invalid; DSS may use these values in consideration of the Cost Proposal. |
Instructions: Complete the Table below using as many rows as needed. Clearly describe the location of references to the RFP and/or Proposal, description of the assumption, rationale for the need of the assumption, and the cost impact to DSS should the assumption be invalid. Insert additional rows as needed.
| Table 1. Cost Assumptions | ||||
| Item # | Proposal Section, Page, Paragraph, Tab | Description | Rationale | Cost Impact If The Assumption is Invalid |
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 | ||||
| 13 | ||||
| 14 | ||||
| 15 | ||||
| 16 | ||||
| 17 | ||||
| 18 | ||||
| 19 | ||||
| 20 |
&"Arial,Regular"&A
&"Arial,Regular"&9&F &"Arial,Regular"&9&P of &N
File details come from the government source that posted it. Updated .