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

File Type Posted
PL 001.xlsx XLSX spreadsheet
ATTM 003.pdf PDF
PL0019 - CGIS VLP.pdf PDF
ATTM 010.docx DOCX document
PL0019 - Foster Care.pdf PDF
ATTM 011.docx DOCX document
Amendment 2.docx DOCX document
ATTM 007.pdf PDF
PL0019 - CGIS11.pdf PDF
PL 017.pdf PDF
PL 005 - updated.pdf PDF
ATTM 015.docx DOCX document
PL0019 - CGIS29.pdf PDF
PL 004 - updated.pdf PDF
PL0019 - CGIS36.pdf PDF
ATTM 001.pdf PDF
PL0019 - CGIS18.pdf PDF
Amendment 1.docx DOCX document
PL 002 - updated.xlsx XLSX spreadsheet
PL 006.pdf PDF
PL0019 - CGIS12.pdf PDF
PL 016.pdf PDF
PL 013.pdf PDF
PL 008.pdf PDF
ATTM 002.pdf PDF
ATTM 004.docx DOCX document
ATTM 006.docx DOCX document
PL 015.pdf PDF
PL0019 - CGIS28.pdf PDF
PL 010.pdf PDF
ATTM 005.pdf PDF
PL 003.pdf PDF
ATTM 013.docx DOCX document
PL 009.pdf PDF
PL 018.pdf PDF
Solicitation.docx DOCX document
PL0019 - CGIS30.pdf PDF
ATTM 016.docx DOCX document
Award Posting Notice 21308.doc DOC document
PL0019 - CGIS38.pdf PDF
PL 012.pdf PDF
PL 011.pdf PDF
Award Extension 21308.doc DOC document
ATTM 014.docx DOCX document
PL0019 - CGIS31.pdf PDF
PL0019 - CGIS33.pdf PDF
ATTM 012.pdf PDF
PL 014.pdf PDF
PL 007.pdf PDF
ATTM 008 - updated.xlsx XLSX spreadsheet
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
TableTitle
Pricing Table AInitiation
Pricing Table BMaintenance and Hosting
Pricing Table CLabor Rate - Year 1
Pricing Table DLabor Rate - Year 2
Pricing Table ELabor Rate - Year 3
Pricing Table FLabor Rate - Year 4
Pricing Table GLabor Rate - Year 5
Pricing Table HLabor Rate - Year 6
Pricing Table ILabor Rate - Year 7
Pricing Table KModification Pool
Pricing Table LTurnover
Pricing Table MTotal 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 NameContract Month of MilestoneFixed PricePayment 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%
20INITIATION ACTIVITIES & MIGRATION COMPLETE / ASSUMPTION OF O&E0$ -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 Month7
Contract YearMaintenance Fixed Price Per MonthHosting Fixed Price Per MonthPrice per MonthPrice 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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 CategoryPercent 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
Total0%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 YearAmount Used in
Contract TPVAmount 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 PhaseM
Contractor:0%D
Milestone/Deliverable NumberProposed 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 TableTotal Potential ValueTotal 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 .