Appendix C AMS RFP Cost Proposal.xlsx
XLSX spreadsheet 153 KB Posted
- Attached to
- DOIT - Managed Application Services
- Solicitation number
- RFP27006832
- Issued by
- Providence County, Rhode Island
About this file
This is a cost proposal document for Application Managed Services (AMS) submitted to the Rhode Island Division of Enterprise Technology Strategy and Services (ETSS) within the Department of Administration in response to RFP27006832. The proposal covers managed application services for state-operated applications across three service areas: Low Code applications (Salesforce and Workday), Mainframe and Legacy systems (COBOL and Oracle), and infrastructure support. The contract period runs approximately three years beginning January 1, 2027, with optional renewal periods of up to two additional 24-month terms contingent on vendor performance and fund availability. Proposals were due August 11, 2026 at 10:00 a.m. EDT, with a vendor Q&A period running from July 14, 2026 through July 27, 2026. The proposal allocation includes a total staffing model of 20 full-time equivalents distributed across four onsite leads, four onshore developers, and twelve offshore developers.
The three-year cost proposal totals $24,418,336 for fixed price and time and materials services combined, with an estimated contingency reserve of $2,312,750 (10 percent), bringing the total with contingency to $26,731,086. Pricing is structured as fixed annual fees for known applications ($4,790,000 in Year 1) combined with time and materials rate cards for additional work, with hourly rates ranging from $55 to $195 depending on role and location (onsite leads at $185-$195, onshore developers at $135-$145, and offshore developers at $55-$60). The proposal includes a 3 percent annual escalation factor applied across all years. The State reserves the right to award based on cost alone and to withhold a 0.33 percent contract administrative fee from all invoices. Required insurance includes general liability of $1,000,000 combined single limit, professional liability of $2,000,000, technology errors and omissions of $5,000,000, and umbrella liability of $1,000,000. Minority and women-owned business enterprise participation is required throughout contract performance.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP27006832_Jul_15_26_solicitation_doc.pdf | ||
| Supplemental Bidder Attestation - 12-01-2025 (1).pdf | ||
| Addendum B RI General Conditions of Purchase - IT Policies.docx | DOCX document | |
| Appendix D Security Questionnaire.xlsm | XLSM spreadsheet | |
| Addendum B RI General Conditions of Purchase - IT Policies - Revised.docx | DOCX document | |
| RFP27006832 Solicitation Specifications.pdf | ||
| RFQ27006835 Generator SOW.pdf | ||
| RFP27006832_Jul_20_26_solicitation_doc.pdf | ||
| Addendum E Business Associate Agreement.docx | DOCX document | |
| Appendix F Vendor Checklist to RI GCOP Addendum B IT Policies - Revised.xlsx | XLSX spreadsheet | |
| RFP27006832 Questions and Answers.xlsx | XLSX spreadsheet | |
| Exhibit 1 AMS Minimum Service Level Agreement.docx | DOCX document | |
| Appendix F Vendor Checklist to RI GCOP Addendum B IT Policies.xlsx | XLSX spreadsheet | |
| ISBE Form - RFP Appendix B - 12.01.2025.pdf | ||
| Appendix E RI ETSS Application Inventory.docx | DOCX document | |
| RFP27006832_Aug_10_26_solicitation_doc.pdf |
Show all 16
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
Executive Summary
| APPLICATION MANAGED SERVICES - 3 YEAR COST PROPOSAL | ||
| PRICING MODEL OVERVIEW | ||
| Fixed Price - Known Applications (Annual) | ||
| Low Code (Salesforce, Workday) - Year 1 | $2,840,000 | |
| Mainframe & Legacy (COBOL/Oracle) - Year 1 | $1,950,000 | |
| Hourly Rate Card (T&M for Additional Work) | ||
| Onsite Lead Rate (US-based) | $185/hour | 2,000 hrs/year |
| Onshore Developer Rate (US-based) | $135/hour | 2,000 hrs/year |
| Offshore Developer Rate (India/SE Asia) | $55/hour | 2,000 hrs/year |
| 3-YEAR TOTAL INVESTMENT | ||
| Fixed Costs (3 years) | $13,410,000 | |
| T&M Rate Card (3 years estimated) | $7,020,000 | |
| ESTIMATED TOTAL 3-YEAR COST | $20,430,000 | |
| Average Annual Cost | $6,810,000 |
Fixed Price Annual (2) APPLICATION AREA Year 1 Year 2 Year 3 3-YEAR TOTAL Notes
| LOW CODE APPLICATIONS | Phase 1 Apps | assumed staffing | 3 % inflation and 10% prod | 4 % inflation and 10% prod | |||
| Salesforce CRM/Platform | CCC an DEM | 1 onsite - 1 onshore - 3 offshore | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Workday HCM Module | HCM / Payroll [+ OSV] | 1 onsite - 1 onshore - 6 offshore | $ 1,200,000.00 | $ 1,200,000.00 | $ 1,200,000.00 | $ 3,600,000.00 | |
| Workday Finance Module | Finance + Future OSP Proactis + EUNA Grants Ingegration role? | 1 onsite - 1 onshore - 6 offshore | $ 1,200,000.00 | $ 1,200,000.00 | $ 1,200,000.00 | $ 3,600,000.00 | Year 1 - may not have OSP |
| Low Code Subtotal | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| MAINFRAME & LEGACY APPLICATIONS | 1 lead onsite - 1 Sr Dev onshore | 480000 | 480000 | 480000 | 1440000 | ||
| Mainframe Management & Support | 3 FTE offshore | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | 720000 | ||
| Legacy COBOL Applications | 3 FTE | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | 720000 | ||
| Oracle Legacy Systems | 3 FTE | $ 300,000.00 | $ 300,000.00 | $ 300,000.00 | 900000 | ||
| Mainframe/Legacy Subtotal | 1260000 | 1260000 | 1260000 | 3780000 | |||
| TOTAL FIXED PRICE (All Areas) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| Annual Growth Rate | 5% | 4.77% | 4.77% |
AMS Cost Proposal Year 1 Year 2 Year 3 3-YEAR TOTAL
| Group 1 - LOW CODE APPLICATIONS | Service Type | Apps in scope | additional Discretionary hours per year | additional Discretionary hours per year | Knowledge Transition [if any] | Annual Fixed Price Fee | Monthly Fixed Price Fee | Discretionary hrs Fee | Annual Fixed Price Fee | Monthly Fixed Price Fee | Discretionary hrs | Annual Fixed Price Fee | Monthly Fixed Price Fee | Discretionary hrs | |
| 1. Salesforce CRM/Platform | Managed Service | Phase 1 - 2 Apps [CCC, DEM] | Assume 3000 in year 1 ; 4000 in year 2 ; 5000 hours in year 3 [Vendor to assume and propose a blended rate ] | 1000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2. Salesforce CRM/Platform | Managed Service | Phase 2 Apps - 2 Apps [Rises , Crisis Care] | $ - 0 | NA | NA | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3. Workday HCM Module | Managed Service | Phase 1 - HCM / Payroll + Fin | 1000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
tc={9CA38F26-B387-4F30-963D-AAF7EFD938DF}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
mplementation phases of the ERP platform under the Change Order as described herein (the “Services”). The Services consist of (i) Application Managed Services (AMS) and (ii) incremental services as set forth below and illustrated in Table 1 (Support Levels) below.
1.1 In-Scope - Workday Modules / Functions
Managed Services and Shared Services support will include the following Workday modules and functions.
Human Capital Management (HCM): Compensation; Benefits; Absence; Time Tracking; United States Payroll; Talent Management; Learning Management Service (LMS); Recruiting; Scheduling Finance (FIN): Business Assets; Banking & Settlement; Customer Accounts; Projects; Grants (post-award); Supplier Accounts; Procurement; Expenses
Help; Value, Inclusion, Belonging and Equity (VIBE); Prism Analytics; People Analytics *Help is removed from scope via Change Order 31
| 4. Microsoft | Managed Service | Phase 2 - Power apps - 18 | 500 | $ - 0 | NA | NA | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 5. Service Now | Managed Service | Phase 2 - ITSM | NA | $ - 0 | NA | NA | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 |
| 6. Low Code consulting | Advisory | Phase 1 - Provide Actitectural and Design | 1000 | $ - 0 | NA | NA | $ - 0 | NA | NA | $ - 0 | NA | NA | $ - 0 | $ - 0 |
| Low Code Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Group 2 - MAINFRAME & LEGACY APP | $ - 0 | ||||||||||
| 1. Mainframe/Legacy Subtotal | Staff Aug | IBM AS/400 | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 2. Legacy COBOL | Staff Aug | DLT App | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 3. Informix | Staff Aug | 2 apps - | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 4. .NET | Staff Aug | support agency | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5. Oracle Systems | Staff Aug | Database - DOT FMS App+ DOC | NA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Mainframe/Legacy Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL FIXED PRICE (All Areas) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Assumption / Instructions | Vendor to fill in items in Green |
| Vendro to assume for " Low code Group 1 " - Minor enhancments up to 40 hours per month | |
| Cells marked NA should not to be filled |
mplementation phases of the ERP platform under the Change Order as described herein (the “Services”). The Services consist of (i) Application Managed Services (AMS) and (ii) incremental services as set forth below and illustrated in Table 1 (Support Levels) below.
1.1 In-Scope - Workday Modules / Functions
Managed Services and Shared Services support will include the following Workday modules and functions.
Human Capital Management (HCM): Compensation; Benefits; Absence; Time Tracking; United States Payroll; Talent Management; Learning Management Service (LMS); Recruiting; Scheduling Finance (FIN): Business Assets; Banking & Settlement; Customer Accounts; Projects; Grants (post-award); Supplier Accounts; Procurement; Expenses
Help; Value, Inclusion, Belonging and Equity (VIBE); Prism Analytics; People Analytics *Help is removed from scope via Change Order 31
T&M Rate Card
| List the Skills | Tech Stack | Experience | Hourly Rate | Hourly Rate | Hourly Rate | |
| Onsite | Onshore | Offshore | ||||
| 1.1 | Low Code – Salesforce | Developer | ||||
| 1.2 | Low Code WorkDay | Developer | ||||
| 1.3 | Low Code Service Now | Developer | ||||
| 1.4 | Low Code Microsoft | Developer | ||||
| 1.5 | Architect | Across Low Code Tech | ||||
| 2. | Legacy COBOL | Programmer | ||||
| 3 | Mainframe | Administrator/Programmer | ||||
| 4 | Oracle Database | Programmer |
Cost Buildup - Low Code
| LOW CODE APPLICATION AREA - DETAILED COST BUILDUP | ||||
| RESOURCE STAFFING PLAN | ||||
| Role | Location | Quantity | Hourly Rate | Annual Hours |
| Lead Architect | Onsite (US) | 1 | $185 | 2000 |
| Senior Developer | Onshore (US) | 1 | $135 | 2000 |
| Developer | Offshore | 1 | $55 | 2000 |
| Developer | Offshore | 1 | $55 | 2000 |
| Developer | Offshore | 1 | $55 | 2000 |
| ANNUAL COST CALCULATION - YEAR 1 | ||||
| Onsite Lead | 1 | $185/hr | 2000 hrs | $370,000 |
| Onshore Developer | 1 | $135/hr | 2000 hrs | $270,000 |
| Offshore Developers (x3) | 3 | $55/hr | 2000 hrs | $330,000 |
| Year 1 T&M Subtotal (Variable) | $970,000 | |||
| Fixed Price Annual (Salesforce + Workday) | $2,840,000 | |||
| Year 1 TOTAL - Low Code Area | $3,810,000 | |||
| 3-YEAR PROJECTION (with 3% escalation) | ||||
| Year 1 | Year 2 | Year 3 | 3-Year Total | |
| Fixed Price | $2,840,000 | $2,980,000 | $3,120,000 | $8,940,000 |
| T&M (variable) | $970,000 | $999,100 | $1,029,073 | $2,998,173 |
| Year Subtotal | $3,810,000 | $3,979,100 | $4,149,073 | $11,938,173 |
Cost Buildup - Mainframe
| MAINFRAME APPLICATION AREA - DETAILED COST BUILDUP | ||||
| RESOURCE STAFFING PLAN | ||||
| Role | Location | Quantity | Hourly Rate | Annual Hours |
| Lead Systems Engineer | Onsite (US) | 1 | $195 | 2000 |
| Mainframe Developer | Onshore (US) | 1 | $145 | 2000 |
| Developer | Offshore | 1 | $60 | 2000 |
| Developer | Offshore | 1 | $60 | 2000 |
| Developer | Offshore | 1 | $60 | 2000 |
| ANNUAL COST CALCULATION - YEAR 1 | ||||
| Onsite Lead | 1 | $195/hr | 2000 hrs | $390,000 |
| Onshore Developer | 1 | $145/hr | 2000 hrs | $290,000 |
| Offshore Developers (x3) | 3 | $60/hr | 2000 hrs | $360,000 |
| Year 1 T&M Subtotal (Variable) | $1,040,000 | |||
| Fixed Price Annual (Mainframe Mgmt) | $800,000 | |||
| Year 1 TOTAL - Mainframe Area | $1,840,000 | |||
| 3-YEAR PROJECTION (with 3% escalation) | ||||
| Year 1 | Year 2 | Year 3 | 3-Year Total | |
| Fixed Price | $800,000 | $840,000 | $880,000 | $2,520,000 |
| T&M (variable) | $1,040,000 | $1,071,200 | $1,103,336 | $3,214,536 |
| Year Subtotal | $1,840,000 | $1,911,200 | $1,983,336 | $5,734,536 |
Cost Buildup - Legacy
| LEGACY SYSTEMS (COBOL/ORACLE) - DETAILED COST BUILDUP | ||||
| RESOURCE STAFFING PLAN | ||||
| Role | Location | Quantity | Hourly Rate | Annual Hours |
| Lead Architect - Legacy | Onsite (US) | 1 | $190 | 2000 |
| Senior Developer - Legacy | Onshore (US) | 1 | $140 | 2000 |
| Developer | Offshore | 1 | $58 | 2000 |
| Developer | Offshore | 1 | $58 | 2000 |
| Developer | Offshore | 1 | $58 | 2000 |
| ANNUAL COST CALCULATION - YEAR 1 | ||||
| Onsite Lead | 1 | $190/hr | 2000 hrs | $380,000 |
| Onshore Developer | 1 | $140/hr | 2000 hrs | $280,000 |
| Offshore Developers (x3) | 3 | $58/hr | 2000 hrs | $348,000 |
| Year 1 T&M Subtotal (Variable) | $1,008,000 | |||
| Fixed Price Annual (COBOL/Oracle) | $1,150,000 | |||
| Year 1 TOTAL - Legacy Area | $2,158,000 | |||
| 3-YEAR PROJECTION (with 3% escalation) | ||||
| Year 1 | Year 2 | Year 3 | 3-Year Total | |
| Fixed Price | $1,150,000 | $1,210,000 | $1,270,000 | $3,630,000 |
| T&M (variable) | $1,008,000 | $1,038,240 | $1,069,387 | $3,115,627 |
| Year Subtotal | $2,158,000 | $2,248,240 | $2,339,387 | $6,745,627 |
3-Year Summary
| 3-YEAR MANAGED SERVICES COST SUMMARY | ||||
| COST COMPONENT BREAKDOWN | Year 1 | Year 2 | Year 3 | 3-Year Total |
| FIXED PRICE ANNUAL SERVICES | ||||
| Low Code (Salesforce/Workday) | $2,840,000 | $2,980,000 | $3,120,000 | $8,940,000 |
| Mainframe Management | $800,000 | $840,000 | $880,000 | $2,520,000 |
| Legacy COBOL/Oracle | $1,150,000 | $1,210,000 | $1,270,000 | $3,630,000 |
| Fixed Price Subtotal | $4,790,000 | $5,030,000 | $5,270,000 | $15,090,000 |
| TIME & MATERIALS (T&M) RATE CARD | ||||
| Low Code T&M | $970,000 | $999,100 | $1,029,073 | $2,998,173 |
| Mainframe T&M | $1,040,000 | $1,071,200 | $1,103,336 | $3,214,536 |
| Legacy T&M | $1,008,000 | $1,038,240 | $1,069,387 | $3,115,627 |
| T&M Subtotal (3% escalation) | $3,018,000 | $3,108,540 | $3,201,796 | $9,328,336 |
| COMBINED TOTALS | ||||
| Year Subtotal (Fixed + T&M) | $7,808,000 | $8,138,540 | $8,471,796 | $24,418,336 |
| COST EFFICIENCY METRICS | ||||
| Cost per FTE per Year (20 FTEs) | $390,400 | $406,927 | $423,590 | $407,287 |
| Monthly Average Cost | $650,667 | $678,212 | $706,150 | $678,014 |
| Daily Average Cost (260 work days) | $30,031 | $31,290 | $32,584 | $31,304 |
Assumptions & Notes
| KEY ASSUMPTIONS & ESCALATION FACTORS | ||
| STAFFING MODEL | ||
| Total FTE Resources Allocated | 20 | |
| By Role: | ||
| Onsite Leads (4 leads @ 1 lead per area) | 4 | US-based, full onsite |
| Onshore Developers (4 devs @ 1 per area) | 4 | US-based (nearshore alternative) |
| Offshore Developers (12 devs @ 3 per area) | 12 | India/SE Asia based |
| HOURLY ASSUMPTIONS | ||
| Annual Hours per Resource | 2,000 | 250 work days x 8 hours/day |
| Accounts for: | Training, meetings, overhead | |
| RATE ASSUMPTIONS - 2026 MARKET BENCHMARKS | ||
| Onsite Lead Rates | ||
| Low Code Lead (Salesforce/Workday) | $185 | US-based, premium expertise required |
| Mainframe Lead | $195 | Specialized mainframe skills |
| Legacy Systems Lead (COBOL/Oracle) | $190 | Specialized legacy expertise |
| Onshore Developer Rates (US-based) | ||
| Low Code Developer | $135 | US-based, full-stack required |
| Mainframe Developer | $145 | US-based, specialized COBOL/JCL |
| Legacy Developer (COBOL/Oracle) | $140 | US-based, older tech stack |
| Offshore Developer Rates (India/SE Asia) | ||
| Low Code Developer | $55 | Distributed hours, async support |
| Mainframe Developer | $60 | Specialized expertise, higher cost |
| Legacy Developer (COBOL/Oracle) | $58 | Specialized legacy expertise |
| RATE ESCALATION | ||
| Annual Escalation Factor | 3% | Applied Year 1 to Year 2 to Year 3 |
| Justification | Merit increases, market adjustments, inflation | |
| PRICING STRUCTURE | ||
| Fixed Price Component | Core AMS for known, stable applications | |
| T&M Rate Card Component | Additional work, enhancements, projects | |
| Billing Method (T&M) | Actual hours utilized at approved rates | |
| RISK & CONTINGENCY | ||
| Contingency Reserve Recommended | 10-15% | For unforeseen requirements |
| Suggested Contingency Amount (3-year) | $2,312,750 | 10% of 3-year total |
| WITH CONTINGENCY - 3 YEAR TOTAL | $26,731,086 |
image1.png
File details come from the government source that posted it. Updated .