3._Cost_Workbook_-_Volume_2.xlsx
XLSX spreadsheet 42 KB Posted
- Solicitation number
- 0000000576
- Issued by
- Sacramento County, California
About this file
This is a cost workbook template from CalSTRS for a hosted solution maintenance and operations contract spanning 3 years with two 1-year options. The workbook requires bidders to provide pricing for various components including transition period costs, SAP security assessment, disaster recovery strategy, steady-state maintenance and operations, and termination costs. The scope involves handling transaction volumes averaging over 23 million dialog steps per month, with an assumed 1% annual increase over the base volume of 279 million transactions in Year 1.
The pricing structure requires fully loaded hourly rates inclusive of all overhead, travel, expenses, and profit, with no additional costs to be added. The workbook is divided into five schedules: fixed costs, fixed cost details, variable charges, hourly rates (both onshore and offshore), and optional services related to BusinessDirect transformation and modernization. Proposers must provide detailed breakdowns of costs for each phase, including resource assignments, durations, and pass-through costs. All costs must be in US dollars, and proposers are required to include applicable taxes for taxable items.
View the file
Other files
Show all 22
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Enter full name of Proposer in the following row (Example: ABC Corporation). |
| (Insert Proposer Name) |
General Instructions
| 1. All hourly rates entered in this cost template must be fully loaded to include all overhead, travel, expenses, and profit. There will be nothing else added to these rates. |
| 2. All cost amounts must be in US dollars. Proposers to include applicable taxes for taxable items. |
| 3. Cost Allocation to Time - Proposers are required to spread any costs that will be incurred by CalSTRS over the time periods shown in each schedule of this cost workbook. |
| 4. For any schedule that contains services, the Proposer must ensure that any totals are accurate. |
&A
Bid Summary
| Proposer: (Insert Proposer Name) | ||||||||
| Bid Summary By Year | ||||||||
| Proposer's Cost Proposal | ||||||||
| Overall Costing Period | ||||||||
| Implementation and Warranty | ||||||||
| Schedule | Mandatory M&O Elements Without Options | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |
| 1 | Fixed Fee Costs | $0 | $0 | $0 | $0 | $0 | $0 | |
| 3 | Variable Costs | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total | Mandatory M&O Elements Without Options | |||||||
| (used for Cost Proposal Evaluation) | $0 | $0 | $0 | $0 | $0 | $0 |
| 5 | Total Options (RFP Section 9) | $0 | $0 | $0 | $0 | $0 | $0 |
| Total | Mandatory M&O Elements + Options | $0 | $0 | $0 | $0 | $0 | $0 |
&A
Sch 1 Fixed Costs
| Proposer: (Insert Proposer Name) |
| Schedule 1 - Maintenance and Operations Charges |
| For CalSTRS Hosted Solution - 3 Years with 2 1-Year Options |
| Proposer's Cost Proposal |
| ANNUAL RESOURCE BASELINES | ||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Transaction Volumes (currently averaging more than 23 million dialog steps/month) 279,000,000 Assume 1% increase over Year 1 Assume 1% increase over Year 2 Assume 1% increase over Year 3 Assume 1% increase over Year 4
# Service Requests assumed in fixed fee pricing
Increase in number of service requests to trigger price adjustment
| Fixed charge per Year | |||||
| Fixed charge: (Please specify what is covered e.g. # tickets, changes, service requests…) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| 1. Transition Period - see 8.3.1 | |||||
| 2. SAP Security Assessment - see 8.3.4 | |||||
| 3. Disaster Recovery Strategy - see 8.3.5 | |||||
| 4. Steady State Fee for Maintenance and Operations | |||||
| 5. Termination Costs | |||||
| {other annual charges} |
| {Add more rows as needed} | |||||
| Total Annual Cost | $0 | $0 | $0 | $0 | $0 |
&A
Sch 2 Fixed Cost Detail
| Proposer: (Insert Proposer Name) |
| Schedule 2 - Details of Fixed Costs |
| For CalSTRS Hosted Solution - 3 Years with 2 1-Year Options |
| Proposer's Cost Proposal |
| NOTE: All hourly rates quoted must be fully "loaded" to capture all direct and overhead expenses, travel, per diem, and any other travel-related expenses. |
(Proposer may add rows to this table as necessary)
1. Transition Costs
| Phase / Milestone | Estimated Duration | Resources Assigned (by title) | Total Cost | |
| Project Management | 3 months | Project Manager, Project coordinator | $$$$$$ | (Example) |
| Finalize Request Process | 2 months | Solution Architect, Business analyst | $$$$$$ | (Example) |
Travel Expense Estimate Total (if applicable) $$$$$$
| Total Transition Costs | $0 | |
| 2. SAP Security Assessment |
| Phase / Milestone | Estimated Duration | Resources Assigned (by title) | Total Cost | |
| Project Management | 3 months | Project Manager, Project coordinator | $$$$$$ | (Example) |
| Finalize Request Process | 2 months | Solution Architect, Business analyst | $$$$$$ | (Example) |
Travel Expense Estimate Total (if applicable) $$$$$$
| Total SAP Security Assessment Costs | $0 | |
| 3. Disaster Recovery Strategy |
| Phase / Milestone | Estimated Duration | Resources Assigned (by title) | Total Cost | |
| Project Management | 3 months | Project Manager, Project coordinator | $$$$$$ | (Example) |
| Finalize Request Process | 2 months | Solution Architect, Business analyst | $$$$$$ | (Example) |
Travel Expense Estimate Total (if applicable) $$$$$$
Total Disaster Recovery Costs $0
5. Termination Costs
| Phase / Milestone | Estimated Duration | Resources Assigned (by title) | Total Cost | |
| Project Management | 3 months | Project Manager, Project coordinator | $$$$$$ | (Example) |
| Finalize Request Process | 2 months | Solution Architect, Business analyst | $$$$$$ | (Example) |
Travel Expense Estimate Total (if applicable) $$$$$$
| Total Termination Costs | $0 | |
| Pass Through Costs |
| Category | Vendor | Interval | Total Cost | |
| Software product maintenance | ABC Corp | Annually | $$$$ | (Example) |
Total Pass Through Costs $0
&A
Sch 3 Variable Costs
| Proposer: (Insert Proposer Name) |
| Schedule 3 - Variable Charges |
| For CalSTRS Hosted Solution - 3 Years with 2 1-Year Options |
| Proposer's Cost Proposal |
| NOTE: All hourly rates quoted must be fully "loaded" to capture all direct and overhead expenses, travel, per diem, and any other travel-related expenses. |
(Proposer may add rows to this table as necessary)
| Annual variable costs: If applicable please specify what is covered based on the provided assumptions e.g. changes and/or service requests etc.) | Unit Pricing (please calculate annual cost for each item) | ||||||
| Item | Units | Unit Cost | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| {example: Storage} | {1GB} | {$200/year) | $X.XX' |
{Add more rows as needed}
Total Annual Cost $0 $0 $0 $0 $0
&A
Sch 4 Hourly Rates
| Proposer: (Insert Proposer Name) |
| Schedule 4 -- Hourly Rates |
| For CalSTRS Hosted Solution - 3 Years with 2 1-Year Options |
| Proposer's Cost Proposal |
| NOTE: All hourly rates quoted must be fully "loaded" to capture all direct and overhead expenses, travel, per diem, and any other travel-related expenses. |
(Proposer may add rows to this table as necessary)
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
| Role | On Shore | Off Shore | On Shore | Off Shore | On Shore | Off Shore | On Shore | Off Shore | On Shore | Off Shore |
| {E.g. Project Manager} |
&A
Sch 5- Optional Costs
| Proposer: (Insert Proposer Name) | |||||||
| Schedule 5 - Pricing for Optional Services | |||||||
| For CalSTRS Hosted Solution - 3 Years with 2 1-Year Options | |||||||
| Proposer's Cost Proposal | |||||||
| This worksheet tab refers to the Maintenance and Operations of BusinessDirect RFP Section 9: Transform and Modernize. Please review this section for more information. | |||||||
| Implementation and Warranty | |||||||
| Item Number | Optional Service | Description | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| {01} | {E.g. re-architecture of SAP environment} | {E.g. Improve performance of reporting and transaction processing to accommodate HANA technologies} | $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 | |||
| Total Cost | $0 | $0 | $0 | $0 | $0 |
&A
File details come from the government source that posted it. Updated .