27-05 Pricing Schedule.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- 142927
- Issued by
- Howard County, Maryland
About this file
This is an official vendor pricing schedule for the Columbia Association's Enterprise Resource Planning (ERP) Software and Services modernization initiative, identified as RFP-27-05. The procurement seeks a comprehensive ERP solution with software licensing, professional implementation services, and ongoing post-implementation support over a five-year period. The pricing schedule is structured to collect vendor proposals across four primary schedules: SaaS subscriptions for years one through five, professional implementation services during the implementation period (project initiation through go-live, final acceptance, and 60-day hypercare), post-implementation support and maintenance for five years, and professional services rate cards. Implementation must address ten mandatory project milestones spanning five months or more, including project initiation, chart of accounts mapping, accounts receivable and rules-based billing engine configuration, procurement and contract setup, mobile-first enterprise asset management deployment, systems integration and API middleware, enterprise data migration, training, system testing with security audits, and cutover with hypercare stabilization.
Vendor pricing must comply with strict requirements: Years 1 and 2 software subscription unit rates remain fixed with annual escalation for Years 3-5 not exceeding 3.0%; professional implementation services are subject to mandatory 10% payment retention; and hourly rates established in the rate card serve as contractually binding maximum rates for change orders and mandatory disentanglement services of up to one year. The pricing schedule requires vendors to populate all light blue input cells with specific quantities, costs, hourly rates, and hours, while prohibiting any insertion, deletion, or reordering of rows or columns. The implementation period encompasses all labor and services required through final acceptance and hypercare completion, and vendors must identify assumptions regarding cost allocations if implementation activities extend beyond one fiscal year. The five-year total cost of ownership calculation treats implementation as a one-time Year 1 cost, with subscription years and support years representing annual recurring costs for evaluation purposes.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ERP Vendor Compliance Response Guide.pdf | ||
| ERP Requirements Traceability Matrix.xlsx | XLSX spreadsheet | |
| RFP 27-05 ERP Software and Services 9.8.26.pdf | ||
| Vendor Compliance Response Workbook.xlsx | XLSX spreadsheet | |
| Minority Business Enterprise (MBE) Participation Form.docx | DOCX document |
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
TOC & Vendor Guide
| COLUMBIA ASSOCIATION — ERP MODERNIZATION | ||
| RFP-27-05: Enterprise Resource Planning Software & Services | ||
| OFFICIAL VENDOR PRICING SCHEDULE | ||
| COLOR CONVENTION LEGEND | ||
| Color Role | Cell Sample | Instructions for Bidders |
| Vendor Input Field | [ Vendor Input ] | Light Blue cells require direct vendor input. Enter numbers, counts, descriptions or rates. |
| Formula / Calculated Output | [ Auto-Computed ] | Light Green cells are locked formula outputs. Do not alter these cells. |
| Fixed Label / Baseline | [ Read-Only Label ] | Zebra / white rows with fixed labels |
| GENERAL SUBMISSION INSTRUCTIONS | ||
| 1. Bidders must fully complete all light blue 'Vendor Input' cells in this workbook. | ||
| 2. Do not insert, delete, or re-order rows or columns on any sheet. Re-keying or structural changes may lead to disqualification. | ||
| 3. Pricing Terminology and Period Definitions |
Subscription Years (Schedule A):
Schedule A shall be completed using Subscription Year 1 through Subscription Year 5 pricing. Each Subscription Year represents a twelve (12) month subscription period.
Implementation Period (Schedule B):
The Implementation Period begins at contract execution and continues through Go-Live, Final Acceptance, and completion of the required 60-day Hypercare period. All implementation-related services, including project management, configuration, data migration, integrations, testing, training, cutover, stabilization, and hypercare activities, shall be included in Schedule B.
Support Years (Schedule C):
Schedule C shall be completed using Support Year 1 through Support Year 5 pricing. Each Support Year represents a twelve (12) month support and maintenance period following commencement of ongoing production support services.
If implementation activities extend beyond twelve (12) months, Vendors shall identify any assumptions or pricing implications in the assumptions section provided within this workbook.
| 4. Price Protection: Under CA RFP guidelines, Years 1 and 2 software subscription unit rates must remain fixed. Annual escalation for Years 3-5 must not exceed 3.0% | ||
| 5. Payment Retention: Professional implementation services are subject to a mandatory ten percent (10%) payment retention | ||
| 6. Disentanglement: Labor rates card defined in Tab 5 represents contractually binding maximum hourly rates for transition support | ||
| PRICING SCHEDULE MODULES (TABLE OF CONTENTS) | ||
| Schedule | Pricing Module Description | Navigation Link |
| Schedule A | SaaS Subscriptions: 5-Year licensing pricing and license volumes | Go to sheet → |
| Schedule B | Implementation Services: LCAT rates, LCAT hours, and 10% retention calculations | Go to sheet → |
| Schedule C | Post-Implementation Services: Helpdesk, updates | Go to sheet → |
| Schedule D | Rate Cards & Disentanglement: binding consulting labor rate cards and exit price caps | Go to sheet → |
| 5-Year TCO Summary | 5-Year TCO Summary Rollup | Go to sheet → |
SaaS Subscriptions
| SCHEDULE A: 5-YEAR SOFTWARE SUBSCRIPTION (SaaS) COSTS | ||||||||
| Instructions: Blue cells require input. Green cells calculate totals. Use the bottom text box to explain any key assumptions used to generate pricing. | ||||||||
| Note: For Schedule A, Subscription Year 1 represents the first twelve (12) months of production subscription services following Go-Live unless otherwise identified by the Vendor. Subscription Years 2 through 5 represent successive twelve-month subscription periods. | ||||||||
| USER LICENSING | ||||||||
| Component Code | Subscription Component / License Tier | No. of Licenses (Qty) | Year 1 Cost ($) | Year 2 Cost ($) | Year 3 Cost ($) | Year 4 Cost ($) | Year 5 Cost ($) | 5-Year Total ($) |
| License Type/User Category | Description | |||||||
| $ - 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 User Licenses | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| REQUIRED SOLUTION COMPONENTS | ||||||||
| Core Module/Subscription Component | Description | Quantity | Year 1 Cost ($) | Year 2 Cost ($) | Year 3 Cost ($) | Year 4 Cost ($) | Year 5 Cost ($) | 5-Year Total ($) |
| ERP Core Financial Platform | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Reporting & Analytics | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Required Application Environments (DEV, QA, UAT, TRN, PROD) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other (Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other (Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other (Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other (Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal Core SaaS Modules | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| REQUIRED THIRD-PARTY PRODUCTS | ||||||||
| Third-Party Products & Services | Description | Quantity | Year 1 Cost ($) | Year 2 Cost ($) | Year 3 Cost ($) | Year 4 Cost ($) | Year 5 Cost ($) | 5-Year Total ($) |
| iPaaS / Integration Middleware | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Customer Portal | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Vendor Portal | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| AI / Intelligent Automation Licensing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Additional Storage / Archive Storage | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| API / Transaction Consumption Fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Security Monitoring / WAF / SIEM Tools | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other Required Third-Party Product (Vendor Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other Required Third-Party Product (Vendor Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other Required Third-Party Product (Vendor Specify) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal Third-Party Modules | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| ONE-TIME NON-RECURRING COSTS | ||||||||
| Cost Item | Description | Total Cost | ||||||
| Data Migration Tools | $0.00 | |||||||
| Environment Provisioning | $0.00 | |||||||
| Training Materials | $0.00 | |||||||
| Third-Party Setup Fees | $0.00 | |||||||
| Other (Specify) | $0.00 | |||||||
| Other (Specify) | $0.00 | |||||||
| Other (Specify) | $0.00 | |||||||
| Subtotal One-Time Costs | $0.00 | |||||||
| OPTIONAL PRODUCTS | ||||||||
| Optional Products & Services | Description | Quantity | Year 1 Cost ($) | Year 2 Cost ($) | Year 3 Cost ($) | Year 4 Cost ($) | Year 5 Cost ($) | 5-Year Total ($) |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal Optional Products & Services | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| SAAS COST SUMMARY | ||||||||
| Description | Quantity | Year 1 Cost ($) | Year 2 Cost ($) | Year 3 Cost ($) | Year 4 Cost ($) | Year 5 Cost ($) | 5-Year Total ($) | |
| User Licensing | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Required Solution Components | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Required Third-Party Products | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| One-Time Costs | $0.00 | N/A | N/A | N/A | N/A | $0.00 | ||
| TOTAL REQUIRED SAAS COST | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Optional Products & Services | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| TOTAL SAAS COST INCLUDING OPTIONS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Annual Subscription Escalation Percentage (Years 3-5): | % |
| Please indicate any key assumptions used to generate the pricing above: |
Implementation Services
| SCHEDULE B: PROFESSIONAL IMPLEMENTATION SERVICES | |||
| Instructions: Define your Project Team Roles / Labor Categories (LCATs), estimated hours, and binding hourly rates. Blue cells require input. | |||
| Implementation Period: For purposes of Schedule B, the Implementation Period begins at contract execution and continues through Go-Live, final acceptance, and completion of the required 60-day hypercare period, regardless of the elapsed calendar duration. | |||
| Labor Category (LCAT) / Consultant Role | Estimated Hours | Hourly Rate ($/Hr) | Total LCAT Cost ($) |
| Project Manager | 0 | $0 | $0 |
| Technical / Solutions Architect | 0 | $0 | $0 |
| Financial ERP Subject Matter Expert (SME) | 0 | $0 | $0 |
| Rules-Based Billing Engine (ACA) SME | 0 | $0 | $0 |
| Enterprise Asset Management (EAM) Specialist | 0 | $0 | $0 |
| Systems Integration (iPaaS) Engineer | 0 | $0 | $0 |
| Data Migration Specialist | 0 | $0 | $0 |
| Change Management Specialist | 0 | $0 | $0 |
| QA / Testing Analyst | 0 | $0 | $0 |
| ERP Lead Trainer | 0 | $0 | $0 |
| Other Labor Category (Specify) | 0 | $0 | $0 |
| Other Labor Category (Specify) | 0 | $0 | $0 |
| Other Labor Category (Specify) | 0 | $0 | $0 |
| Other Labor Category (Specify) | 0 | $0 | $0 |
| Other Labor Category (Specify) | 0 | $0 | $0 |
| TOTAL IMPLEMENTATION PROJECT HOURS & COST | 0 | $0 | |
| Mandatory 10% Services Payment Retention | $0 | ||
| NET IMPLEMENTATION SERVICES PAYABLE (AFTER RETENTION) | $0 |
| Vendor Pricing Approach (Select One): | Fixed Fee | T&M | Hybrid |
| FALSE | FALSE | FALSE | |
| INFORMATIONAL: MANDATORY PROJECT MILESTONES (REFER TO RFP SECTION 4) | |||
| M-01 | Target: Mo. 1 | Project Initiation, Steering Governance & Solution Architecture Blueprint | |
| M-02 | Target: Mo. 2 | Multi-Dimensional Chart of Accounts Mapping & General Ledger Setup | |
| M-03 | Target: Mo. 2-3 | AR, Collections & Rules-Based Billing Engine Build (ACA COBOL Re-engineering) | |
| M-04 | Target: Mo. 3 | Sourcing, Procurement, Multi-Way Matching & Contract Integration Setup | |
| M-05 | Target: Mo. 3-4 | Mobile-First Enterprise Asset Management (EAM) & Facilities Cost Allocations | |
| M-06 | Target: Mo. 4 | Systems Integration Mesh & API Middleware (iPaaS Sync for Dayforce/Club Automation) | |
| M-07 | Target: Mo. 1-4 | Enterprise Data Migration (Profile, Cleanse, Map, Transform, Validate, Migrate) | |
| M-08 | Target: Mo. 4 | Train-the-Trainer (TTT) Laboratories & Persona-Specific Interactive User Guides | |
| M-09 | Target: Mo. 4 | System Integration, Load Testing (Peak Tax Runs) & Penetration Security Audits | |
| M-10 | Target: Mo. 5+ | Go-Live Cutover, Final Acceptance & 60-Day Hypercare Stabilization |
| Implementation pricing shall include all labor and services required through final acceptance, including post-go-live hypercare and stabilization activities. |
| If implementation activities extend beyond one (1) contract year or fiscal year, vendors shall identify any planned cost allocations or assumptions in the assumptions section below. |
Please indicate any key assumptions used to generate the pricing above:
Post-Implementation & TCO
| SCHEDULE C: 5-YEAR POST-IMPLEMENTATION SUPPORT | ||||||
| Instructions: Enter post-implementation ongoing support costs. | ||||||
| Support Year 1 begins upon completion of the Implementation Period and commencement of ongoing production support services. Support Years 2 through 5 represent successive twelve-month support periods thereafter. | ||||||
| Support / SLA Ongoing Component Description | Support Year 1 Cost ($) | Support Year 2 Cost ($) | Support Year 3 Cost ($) | Support Year 4 Cost ($) | Support Year 5 Cost ($) | 5-Year Total ($) |
| Tier 1 (Critical) Support SLAs (24x7x365 Support, 15-Minute Response Target) | $0 | $0 | $0 | $0 | $0 | $0 |
| Tier 2 (High) Support SLA (1 Business-Hour Response Target) | $0 | $0 | $0 | $0 | $0 | $0 |
| Tier 3 (Moderate / Low) Support SLA (4 Business-Hour Response Target) | $0 | $0 | $0 | $0 | $0 | $0 |
| Ongoing Software Maintenance (Release upgrades, hotfixes, security patches, NIST compliance) | $0 | $0 | $0 | $0 | $0 | $0 |
| Continual Annual Training Workshops (Ad-hoc refreshers for new personnel) | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Custom Support Component (Optional / Enter Name) | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Custom Support Component (Optional / Enter Name) | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Support & SLA Maintenance | $0 | $0 | $0 | $0 | $0 | $0 |
| Please indicate any key assumptions used to generate the pricing above: |
Rate Cards & Disentanglement
| SCHEDULE D: PROFESSIONAL SERVICES RATE CARD & DISENTANGLEMENT CAPS | |||
| Note: Hourly rates defined below serve as contractually-binding maximum rates for optional change orders and mandatory Disentanglement Services (up to 1 Year). | |||
| Standard Resource Labor Category (LCAT) | Standard Rate ($/Hr) | Overtime Rate ($/Hr) | RFP Disentanglement Cap ($/Hr) |
| Project Manager | $0 | $0 | $0 |
| Technical / Solutions Architect | $0 | $0 | $0 |
| Financial ERP Subject Matter Expert (SME) | $0 | $0 | $0 |
| Rules-Based Billing Engine (ACA) SME | $0 | $0 | $0 |
| Data Migration Specialist | $0 | $0 | $0 |
| Change Management Specialist | $0 | $0 | $0 |
| QA / Testing Analyst | $0 | $0 | $0 |
| ERP Systems Trainer | $0 | $0 | $0 |
| Business Intelligence & Report Analyst | $0 | $0 | $0 |
| Other (Enter Name) | $0 | $0 | $0 |
| Other (Enter Name) | $0 | $0 | $0 |
| Other (Enter Name) | $0 | $0 | $0 |
5-Year TCO Summary
| 5-YEAR TOTAL COST OF OWNERSHIP (TCO) ROLLUP SUMMARY | ||||||
| For pricing evaluation purposes, Implementation Services are treated as a one-time cost and included in the Year 1 Total Cost of Ownership (TCO) calculation. Subscription Years and Support Years represent annual recurring costs used for five-year TCO evaluation. | ||||||
| Required Costs | Year 1 ($) | Year 2 ($) | Year 3 ($) | Year 4 ($) | Year 5 ($) | 5-Year Total ($) |
| Software Subscriptions (Schedule A) | $0 | $0 | $0 | $0 | $0 | $0 |
| Implementation Services (Schedule B) | $0 | N/A | N/A | N/A | N/A | $0 |
| Ongoing Support & SLA Maintenance (Schedule C) | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Required Costs | $0 | $0 | $0 | $0 | $0 | $0 |
| Optional Costs | $0 | $0 | $0 | $0 | $0 | $0 |
| Grand Total TCO | $0 | $0 | $0 | $0 | $0 | $0 |
File details come from the government source that posted it. Updated .