ATTM 009 - updated.xlsx
XLSX spreadsheet 85 KB Posted
- Attached to
- MMS OPERATIONS AND ENHANCEMENTS
- Solicitation number
- 5400021308
- Issued by
- Richland County, South Carolina
About this file
This is a pricing tables attachment document for a state and local contract opportunity related to system initiation, maintenance, hosting, and operations services. The contract spans seven years with an initiation phase followed by ongoing operations and maintenance phases. The pricing structure is organized into multiple tables covering initiation phase milestones, monthly maintenance and hosting fees, labor rates by year, a modification pool, and a turnover phase. The initiation phase includes up to 20 payment milestones leading to full operational status, with operations commencing in month seven of the contract. Labor pricing is required for all seven contract years with hourly rates by labor category and weighted average calculations. The contract includes a total modification pool of $14,000,000 across all seven years, allocated at $2,000,000 per year, with the modification pool amount based on average labor rates multiplied by 6,750 hours annually.
Contractors are required to provide pricing for fixed-price initiation activities, fixed monthly maintenance and hosting costs, labor category hourly rates with percentage allocations totaling 100 percent, and turnover phase deliverables and milestones. The total cost of ownership calculation aggregates the initiation phase price, maintenance and hosting price across all years, the modification pool, and the turnover phase price. The document is formatted as a blank template for contractors to complete with their specific pricing information, including contractor name, contract start month, and all associated costs. No incumbent information, funding sources, or set-aside requirements are specified in this pricing table attachment.
View the file
Other files
Show all 50
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 - Pricing Tables Blank UPDATED | |
| Table | Title |
| Pricing Table A | Initiation |
| Pricing Table B | Maintenance and Hosting |
| Pricing Table C | Labor Rate - Year 1 |
| Pricing Table D | Labor Rate - Year 2 |
| Pricing Table E | Labor Rate - Year 3 |
| Pricing Table F | Labor Rate - Year 4 |
| Pricing Table G | Labor Rate - Year 5 |
| Pricing Table H | Labor Rate - Year 6 |
| Pricing Table I | Labor Rate - Year 7 |
| Pricing Table K | Modification Pool |
| Pricing Table L | Turnover |
| Pricing Table M | Total Cost of Ownership |
Enter Contractor Name Here --->
Enter Contract month to begin operations --->
A - Initiation Phase
| Pricing Table A - Initiation Phase Prices | ||||
| Contractor: | 0 | |||
| Contract Month of Targeted Fully Operational Start Date: | 0 | |||
| Payment Milestone No. | Milestone Name | Contract Month of Milestone | Fixed Price | Payment Percentage |
| 1 | $ - | 0% | ||
| 2 | $ - | 0% | ||
| 3 | $ - | 0% | ||
| 4 | $ - | 0% | ||
| 5 | $ - | 0% | ||
| 6 | $ - | 0% | ||
| 7 | $ - | 0% | ||
| 8 | $ - | 0% | ||
| 9 | $ - | 0% | ||
| 10 | $ - | 0% | ||
| 11 | $ - | 0% | ||
| 12 | $ - | 0% | ||
| 13 | $ - | 0% | ||
| 14 | $ - | 0% | ||
| 15 | $ - | 0% | ||
| 16 | $ - | 0% | ||
| 17 | $ - | 0% | ||
| 18 | $ - | 0% | ||
| 19 | $ - | 0% | ||
| 20 | INITIATION ACTIVITIES & MIGRATION COMPLETE / ASSUMPTION OF O&E | 0 | $ - | 0% |
| Remove lines as necessary except final Milestone | ||||
| Total Fixed Price | $ - | 0% |
B - Maintenance
| Pricing Table B - Operations Phase - Maintenance & Hosting | ||||
| Contractor: | 0 | |||
| Operations Start Month | 7 | |||
| Contract Year | Maintenance Fixed Price Per Month | Hosting Fixed Price Per Month | Price per Month | Price per Year |
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Maintenance & Hosting Price | $ - 0 |
C - Labor Rates - Year 1
| Pricing Table C - Labor Rates (1) | |||
| Contractor: | 0% | ||
| Contract Year 1 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
D - Labor Rates - Year 2
| Pricing Table C - Labor Rates (2) | |||
| Contractor: | 0% | ||
| Contract Year 2 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
E - Labor Rates - Year 3
| Pricing Table C - Labor Rates (3) | |||
| Contractor: | 0 | ||
| Contract Year 3 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
F - Labor Rates - Year 4
| Pricing Table C - Labor Rates (4) | |||
| Contractor: | 0% | ||
| Contract Year 4 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
G - Labor Rates - Year 5
| Pricing Table C - Labor Rates (5) | |||
| Contractor: | 0% | ||
| Contract Year 5 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
H - Labor Rates - Year 6
| Pricing Table C - Labor Rates (6) | |||
| Contractor: | 0% | ||
| Contract Year 6 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
I - Labor Rates - Year 7
| Pricing Table C - Labor Rates (7) | |||
| Contractor: | 0% | ||
| Contract Year 7 | |||
| Labor Category | Percent Typical Use (%) | Hourly Rate | |
| 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 | 0% | Weighted Average Labor Rate | $ - 0 |
| Must add to 100% |
Add or remove lines as necessary
K - Modification Pool
| Pricing Table K - Modification Pool | ||
| Contractor: | 0% | |
| Contract Year | Amount Used in | |
| Contract TPV | Amount Used in TCO |
(Average Labor Rate X 6,750 Hours)
| Contract Year 1 | $ 2,000,000.00 | $ - 0 |
| Contract Year 2 | $ 2,000,000.00 | $ - 0 |
| Contract Year 3 | $ 2,000,000.00 | $ - 0 |
| Contract Year 4 | $ 2,000,000.00 | $ - 0 |
| Contract Year 5 | $ 2,000,000.00 | $ - 0 |
| Contract Year 6 | $ 2,000,000.00 | $ - 0 |
| Contract Year 7 | $ 2,000,000.00 | $ - 0 |
| Total Modification Pool | $ 14,000,000.00 | $ - 0 |
L - Turnover
| Pricing Table L - Turnover Phase | M | ||
| Contractor: | 0% | D | |
| Milestone/Deliverable Number | Proposed Milestone/Deliverable | $ Amount | |
| 1 | $ - 0 | ||
| 2 | $ - 0 | ||
| 3 | $ - 0 | ||
| 4 | $ - 0 | ||
| 5 | $ - 0 | ||
| 6 | $ - 0 | ||
| 7 | $ - 0 | ||
| 8 | $ - 0 | ||
| 9 | $ - 0 | ||
| 10 | $ - 0 | ||
| 11 | $ - 0 | ||
| 12 | $ - 0 | ||
| Total Turnover Phase Price | $ - 0 |
Delete lines as necessary
M - TCO
| Pricing Table M - Total Cost of Ownership | |||
| Contractor: | 0 | ||
| Pricing Table | Total Potential Value | Total Cost of Ownership | |
| A - Initiation Phase Price | $ - 0 | $ - 0 | $ - 0 |
| B - Maintenance / Hosting Price | $ - 0 | $ - 0 | |
| K - Modification Pool | $ 14,000,000.00 | $ - 0 | |
| L - Turnover Price | $ - 0 | $ - 0 | |
| Total | $ 14,000,000.00 | $ - 0 |
File details come from the government source that posted it. Updated .