ATTM 008 BABYNET PRICING TABLES EXAMPLE.xls
XLS spreadsheet 147 KB Posted
- Attached to
- BABYNET IDEA PART C
- Solicitation number
- 5400018456
- Issued by
- Richland County, South Carolina
About this file
This is a pricing tables example document for the ATTM 008 BabyNet contract, outlining the cost structure for a state and local service delivery contract with contractor Acme. The contract encompasses four distinct phases: implementation, operations, modification, and turnover. The implementation phase spans six contract months with a targeted operational start date in month six, comprised of 11 major milestones with fixed price payments totaling $250,000. The contract includes a base term of three years with two optional renewal years, with the operations phase extending through all base and option years. Labor is provided across eight job categories during implementation and operations phases, with blended hourly rates ranging from $50.75 to $51.10 annually during the base years.
The total contract value is structured with specific pricing mechanisms for each phase: the implementation phase totals $250,000 with a 5 percent withhold pending system acceptance; the modification pool is valued at $305,783.33; annual operations rates are calculated based on a weighted average of member populations, ranging from 1 to 8,500 active beneficiaries, with monthly fees varying from $20,000 to $30,000 depending on year and enrollment levels; and the turnover phase totals $10,000 over four deliverables. The total not-to-exceed contract value for three base years and two option years is $2,152,783.33, with an additional cost to maintain the state's project of $315,000, resulting in a total cost of ownership of $2,268,283.33. Payment terms include acceptance withholding percentages ranging from 2 to 17 percent across implementation milestones.
View the file
Other files
Show all 31
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
| List Of Pricing Tables | |
| Table | Title |
| Pricing Table A | Implementation Phase Prices |
| Pricing Table B | Labor Rates - Implementation |
| Pricing Table C | Labor Rates - Operations |
| Pricing Table D | Modification Pools |
| Pricing Table E | Annual Operations Rates |
| Pricing Table F | Turnover Phase Prices |
| Pricing Table G | Total Cost of Ownership |
Implementation Phase Prices Labor Rates - Implementation Labor Rates - Operations Modification Pools Annual Operations Rates Turnover Phase Prices Total Cost of Ownership
A - Implementation
| Pricing Table A - Implementation Phase Prices | |||||||
| Contractor: | Acme | ||||||
| Contract Month of Targeted Operational Start Date: | 6 | ||||||
| Payment Milestone No. | Milestone Name | Major Milestone | Contract Month of Milestone | Fixed Price | Payment Percentage | Acceptance Withhold | Payment Amount |
| 1 | A | 1 | $ 17,500.00 | 7% | $ 875.00 | $ 16,625.00 | |
| 2 | B | 2 | $ 25,000.00 | 10% | $ 1,250.00 | $ 23,750.00 | |
| 3 | C | * | 3 | $ 32,500.00 | 13% | $ 1,625.00 | $ 30,875.00 |
| 4 | D | 4 | $ 42,500.00 | 17% | $ 2,125.00 | $ 40,375.00 | |
| 5 | E | 5 | $ 32,500.00 | 13% | $ 1,625.00 | $ 30,875.00 | |
| 6 | F | * | 5 | $ 25,000.00 | 10% | $ 1,250.00 | $ 23,750.00 |
| 7 | G | 6 | $ 17,500.00 | 7% | $ 875.00 | $ 16,625.00 | |
| 8 | H | 6 | $ 12,500.00 | 5% | $ 625.00 | $ 11,875.00 | |
| 9 | I | 8 | $ 5,000.00 | 2% | $ 250.00 | $ 4,750.00 | |
| 10 | J | * | 8 | $ 7,500.00 | 3% | $ 375.00 | $ 7,125.00 |
| 11 | K | 9 | $ 7,500.00 | 3% | $ 375.00 | $ 7,125.00 | |
| Add or remove lines as necessary | |||||||
| Actual Operational Start Date Month | * | 6 | $ 25,000.00 | 10% | $ 1,250.00 | $ 23,750.00 | |
| Subtotals | $ 250,000.00 | $ 12,500.00 | $ 237,500.00 | ||||
| System Acceptance Payment - 5% Withhold | 18 | $ 12,500.00 | |||||
| Totals | $ 250,000.00 | 100% | $ 250,000.00 |
B- Labor Rates - Implementation
| Pricing Table B - Labor Rates - Implementation Phase | ||||||
| Contractor: | Acme | |||||
| Rates | ||||||
| Labor Category | Implementation Phase Mod Pool Percentage of Use | Contract Year 1 Rates | Contract Year 2 Rates | Contract Year 3 Rates | Option Year 1 | Option Year 2 |
| 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 |
| $ - 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 Percentage Must Equal 100% | 100.00% | |||||
| Annual Blended Rate | $ 50.75 | $ 51.10 | $ 51.10 | $ 51.10 | $ 51.10 | |
| Two Year Average Blended Rate | $ 50.93 | |||||
| For Evaluation Purposes - Two Year Average Blended Rate x 2,000 Hours | $ 101,850.00 | |||||
| Add or remove lines as necessary |
C - Labor Rates Ops
| 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 | Option Year 1 | Option Year 2 |
| 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 |
| $ - 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 Percentage Must Equal 100% | 100.00% | |||||
| Annual Blended Rate | $ 50.75 | $ 51.10 | $ 51.10 | $ 51.10 | $ 51.10 | |
| Three Year Average Blended Rate | $ 50.98 | |||||
| For Evaluation Purposes - Three Year Average Blended Rate x 4,000 Hours | $ 203,933.33 | |||||
| Add or remove lines as necessary |
D - Modification Pools
| Pricing Table E - Modification Pool | |
| Contractor: | Acme |
| Phase Modification Pool | |
| $305,783 |
E - Operations
| Pricing Table E- Annual Operations Rates | ||||||||
| Contractor: | Acme | |||||||
| Monthly Range of Active Beneficiaries (Members) | Year 1 | Year 2 | Year 3 | Option Year 1 | Option Year 2 | |||
| From | Through | Likelihood | Monthly Fee | Monthly Fee | Monthly Fee | Monthly Fee | Monthly Fee | Contract Total |
| 1 | 4,500 | 1% | $ 22,500 | $ 20,000 | $ 20,000 | $ 20,000 | $ 20,000 | $ 102,500 |
| 4,501 | 6,000 | 94% | $ 25,000 | $ 22,500 | $ 22,500 | $ 22,500 | $ 22,500 | $ 115,000 |
| 6,001 | 7,500 | 4% | $ 27,500 | $ 25,000 | $ 25,000 | $ 25,000 | $ 25,000 | $ 127,500 |
| 7,501 | 8,500 | 1% | $ 30,000 | $ 27,500 | $ 27,500 | $ 27,500 | $ 27,500 | $ 140,000 |
| 100% | ||||||||
| Weighted Average Monthly Rate | $ 25,125 | $ 22,625 | $ 22,625 | $ 22,625 | $ 22,625 | $ 115,625 | ||
| Average Annual Rate | $ 301,500 | $ 271,500 | $ 271,500 | $ 271,500 | $ 271,500 | $ 1,387,500 | ||
| Amount Used for Cost Proposal Evaluation | $ 1,387,500 | |||||||
| Amount Used for Contract Total Potential Value | $ 1,587,000 |
F - Turnover
| Pricing Table F - Turnover Phase | M | ||
| Contractor: | Acme | D | |
| Contract Month to Begin Turnover | 80 | ||
| Milestone/Deliverable Number | Proposed Milestone/Deliverable | Milestone (M) |
or Deliverable (D) $ Amount Anticipated Invoice Date (Contract Month)
| 1 | A | $ 1,000.00 | 37 | |
| 2 | B | $ 2,000.00 | 38 | |
| 3 | C | $ 3,000.00 | 39 | |
| 4 | D | $ 4,000.00 | 40 | |
| Total | $ 10,000.00 |
G - TCO
| Pricing Table G - Total Cost of Ownership | |||||
| Contractor: | Acme | ||||
| Pricing Table | Total Potential Value for 3 Base Years | TPV for 1st Option Year | TPV for 2nd Option Year | Contract Total Potential Value | Total Cost of Ownership |
| A - Implementation Phase | $ 250,000.00 | $ - 0 | $ - 0 | $ 250,000.00 | $ 250,000.00 |
| D - Modification Pool | $ 305,783.33 | $ - 0 | $ - 0 | $ 305,783.33 | $ 305,783.33 |
| E - Annual Operations Rates | $ 1,020,000.00 | $ 330,000.00 | $ 330,000.00 | $ 1,587,000.00 | $ 1,387,500.00 |
| F - Turnover Phase | $ 10,000.00 | $ - 0 | $ 10,000.00 | $ 10,000.00 | |
| Total Not-to-Exceed Contract Value | $ 1,585,783.33 | $ 330,000.00 | $ 330,000.00 | $ 2,152,783.33 | $ 1,953,283.33 |
| Cost to Maintain State's Project | $ 315,000.00 | ||||
| Total Cost of Ownership | $ 2,268,283.33 |
File details come from the government source that posted it. Updated .