ATTM 009 PRICING TABLES_ EXAMPLES.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- MEDICAID ELIGIBILITY OPERATIONS SERVICES
- Solicitation number
- 5400021745
- Issued by
- Richland County, South Carolina
About this file
This pricing tables document outlines the cost structure for the Medicaid Eligibility Operations Services contract in South Carolina, submitted by contractor Acme. The contract encompasses an implementation phase with a targeted operational start date in month 12, followed by a five-year operations period. The implementation phase is structured around four payment milestones: delivery of implementation phase deliverables (20%), acceptance of all deliverables (20%), acceptance of readiness review (20%), and actual operations start date (40%), totaling a firm fixed price of $5,000.
The monthly operational rates are $50,000 annually for years 1-2, escalating to $52,000 for years 3-4 and $55,000 for year 5, generating total operations costs of $3,108,000 over the five-year term. Labor rates are provided for eight job categories (A through H) with percentages of use ranging from 5% to 25%, with hourly rates varying by contract year and category, resulting in an annual blended rate ranging from $50.75 to $51.10 per hour. The modification pool is valued at $510,300 for evaluation purposes and $750,000 for total contract value. The overall contract evaluation cost totals $3,623,300, with a total potential contract value of $3,863,000 inclusive of the implementation fixed price, monthly operational fees, and modification pool allocation.
View the file
Other files
Show all 23
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
List of Tables
| ATTACHMENT 009 - List Of Pricing Tables | |
| Table | Title |
| Pricing Table A | A- Implementation |
| Pricing Table B | B- Monthly Rates |
| Pricing Table C | C- Labor Rates |
| Pricing Table D | D- Modification Pool |
| Pricing Table E | E - Contract TPV |
A- Implementation
| Pricing Table A - Implementation Phase Prices | |||
| Contractor: | Acme | ||
| Contract Month of Targeted Operational Start Date (TOSD): | 12 | ||
| Payment Milestone No. | Milestone Name | Payment Percentage | Payment Amount |
| 1 | Delivery of Implementation Phase Deliverables | 20.00% | $ 1,000.00 |
| Acceptance of All Deliverables | 20.00% | $ 1,000.00 | |
| Acceptance of Readiness Review | 20.00% | $ 1,000.00 | |
| 2 | Actual Operations Start Date (AOSD) | 40.00% | $ 2,000.00 |
Proposed Firm Fixed Price 100% $ 5,000.00
B- Monthly Rates
| Pricing Table B - Monthly Rates | ||
| Contractor: | Acme | |
| Contract Year | Total Monthly Cost | Annual Costs |
| 1 | $ 50,000 | $ 600,000 |
| 2 | $ 50,000 | $ 600,000 |
| 3 | $ 52,000 | $ 624,000 |
| 4 | $ 52,000 | $ 624,000 |
| 5 | $ 55,000 | $ 660,000 |
$ 3,108,000
C- Labor Rates
| Pricing Table C - Labor Rates - Operations and Turnover Phases | ||||||
| Contractor: | Acme | |||||
| Rates | ||||||
| Labor Category | Replacement Phase Mod Pool Percentage of Use | Contract Year 1 Rates | Contract Year 2 Rates | Contract Year 3 Rates | Contract Year 4 Rates | Contract Year 5 Rates |
| A | 10.00% | $100.00 | $102.00 | $102.00 | $102.00 | $102.00 |
| B | 15.00% | $50.00 | $51.00 | $51.00 | $51.00 | $51.00 |
| C | 15.00% | $75.00 | $73.00 | $73.00 | $73.00 | $73.00 |
| D | 25.00% | $50.00 | $51.00 | $51.00 | $51.00 | $51.00 |
| E | 10.00% | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 |
| F | 15.00% | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 |
| G | 5.00% | $30.00 | $31.00 | $31.00 | $31.00 | $31.00 |
| H | 5.00% | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 |
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| $- | $- | $- | $- | $- | ||
| Total Percentage Must Equal 100% | 100.00% | |||||
| Annual Blended Rate | $ 50.75 | $51.10 | $51.10 | $51.10 | $51.10 | |
| Five Year Average Blended Rate | $51.03 | |||||
| For Evaluation Purposes - Five Year Average Blended Rate x 10,000 Hours | $510,300.00 |
Add or remove lines as necessary
D- Modification Pool
| Pricing Table D - Modification Pool | ||
| Contractor: | Acme | |
| Amount Used for Cost Proposal Evaluation | Amount Used for Contract Total Potential Value | |
| $510,300.00 | $750,000.00 |
E - Contract TPV
| Pricing Table E - Contract Total Potential Value Table | ||
| Contractor: | ACME | |
| Price Category | Evaluation Cost | Contract Total Potential Value |
| Implementation Fixed Price | $ 5,000.00 | $ 5,000.00 |
| Monthly Fees Operations | $ 3,108,000.00 | $ 3,108,000.00 |
| Modification Pool | $510,300.00 | $750,000.00 |
Total $ 3,623,300.00 $ 3,863,000.00
File details come from the government source that posted it. Updated .