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

File Type Posted
ATTM 005 HIPAA BUSINESS ASSOCIATE AGREEMENT.docx DOCX document
Solicitation 21745.docx DOCX document
ATTM 006 ORGANIZATIONAL CONFLICT OF INTEREST DISCLOSURE.docx DOCX document
Amend 3 21745.docx DOCX document
Amend 4 21745.docx DOCX document
PL 001 Updated.docx DOCX document
Award Posting Notice 21745.doc DOC document
ATTM 002 OFFERORS CHECKLIST.docx DOCX document
Amend 1 21745.docx DOCX document
ATTM 008 PRICING TABLES_BLANK.xlsx XLSX spreadsheet
ATTM 013 UPDATED.docx DOCX document
ATTM 001 IMPORTANT NOTICE - NONRESIDENTS ONLY.docx DOCX document
ATTM 015 SERVICE PROVIDE SECURITY ASSESSMENT QUESTIONNAIRE.docx DOCX document
ATTM 007 CERTIFICATION FOR CONTRACTS GRANTS LOANS AND COOPERATIV.docx DOCX document
ATTM 012 SLA Updated_v3.docx DOCX document
ATTM 017 Q&A.docx DOCX document
ATTM 010 QUESTIONS TEMPLATE.docx DOCX document
Amend 2 21745.docx DOCX document
Award Extension 21745.doc DOC document
ATTM 016 INCIDENT REPORT.pdf PDF
PL 001 ELIG OPS STAT DATA.docx DOCX document
ATTM 011 CDML Updated.docx DOCX document
ATTM 003 CERTIFICATION REGARDING DEBARMENT SUSPENSION INELIGIBIL.docx DOCX document
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
TableTitle
Pricing Table AA- Implementation
Pricing Table BB- Monthly Rates
Pricing Table CC- Labor Rates
Pricing Table DD- Modification Pool
Pricing Table EE - 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 NamePayment PercentagePayment Amount
1Delivery of Implementation Phase Deliverables20.00%$ 1,000.00
Acceptance of All Deliverables20.00%$ 1,000.00
Acceptance of Readiness Review20.00%$ 1,000.00
2Actual 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 YearTotal Monthly CostAnnual 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 CategoryReplacement Phase Mod Pool Percentage of UseContract Year 1 RatesContract Year 2 RatesContract Year 3 RatesContract Year 4 RatesContract Year 5 Rates
A10.00%$100.00$102.00$102.00$102.00$102.00
B15.00%$50.00$51.00$51.00$51.00$51.00
C15.00%$75.00$73.00$73.00$73.00$73.00
D25.00%$50.00$51.00$51.00$51.00$51.00
E10.00%$25.00$25.00$25.00$25.00$25.00
F15.00%$30.00$30.00$30.00$30.00$30.00
G5.00%$30.00$31.00$31.00$31.00$31.00
H5.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 EvaluationAmount 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 CategoryEvaluation CostContract 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 .