ATTM 009 BABYNET PRICING TABLES BLANK.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 blank pricing template for the BabyNET contract opportunity, a state and local services contract. The document establishes the framework for contractor pricing submissions across multiple contract phases spanning a base term of three years with two optional renewal years. The template is structured to capture pricing for implementation, operations, and turnover phases, with labor rates categorized by job classifications for each phase. The contract contemplates the management of active beneficiaries ranging from 4,500 to 8,500 members monthly, with weighted probability distributions applied across four membership tiers.

The pricing structure comprises seven primary components: Implementation Phase Prices (with ten major milestones plus system acceptance), Labor Rates for Implementation (eight labor categories with percentage-of-use allocations), Labor Rates for Operations and Turnover (eight labor categories across contract years), Modification Pools, Annual Operations Rates (scaled by membership volume), Turnover Phase Prices, and Total Cost of Ownership calculations. The template incorporates a 10% payment withhold during the implementation phase and a 5% system acceptance withhold, with cost evaluations based on two-year average blended labor rates for implementation (calculated at 2,000 hours annually) and three-year average blended rates for operations (calculated at 4,000 hours annually). All pricing fields are currently blank, indicating this is a standard solicitation form awaiting contractor submission of specific costs for the implementation, labor, operations, modification, and turnover components of the contract.

View the file

Other files

File Type Posted
PL 008 TRA RAW DATA LAKE.docx DOCX document
ATTM 007 CERTIFICATION FOR CONTRACTS GRANTS LOANS AND COOPERATIV.docx DOCX document
ATTM 013 EXPERIENCE TABLE.docx DOCX document
ATTM 010 QUESTIONS TEMPLATE.docx DOCX document
ATTM 006 ORGANIZATIONAL CONFLICT OF INTEREST DISCLOSURE.docx DOCX document
PL 006 TRA MANAGED FILE TRANSFER.docx DOCX document
Award Extension.pdf PDF
PL 002 TRA INTEGRATION HUB.docx DOCX document
ATTM 008 BABYNET PRICING TABLES EXAMPLE.xls XLS spreadsheet
PL 003 TRA ENTERPRISE SERVICE BUS.docx DOCX document
ATTM 001 IMPORTANT NOTICE - NONRESIDENTS ONLY.docx DOCX document
ATTM 014 LIST OF INCLUDED SYSTEM REPORTS.docx DOCX document
ATTM 004 DISCLOSURE OF OWNERSHIP.docx DOCX document
ATTM 011 CDML.docx DOCX document
PL 004 TRA WEB SERVICES.docx DOCX document
ATTM 002 OFFERORS CHECKLIST.docx DOCX document
ATTM 003 CERTIFICATION REGARDING DEBARMENT SUSPENSION INELIGIBIL.docx DOCX document
PL 007 TRA ENTERPRISE DATA SERVICES.docx DOCX document
PL 011 OandM MANUAL TEMPLATE.pdf PDF
ATTM 012 SERVICE LEVEL AGREEMENTS (SLA).docx DOCX document
Solicitation.pdf PDF
PL 005 TRA EXTRACT TRANSFORM LOAD.docx DOCX document
Award Notice.pdf PDF
Amendment #1.pdf PDF
ATTM 015 SPSAQ (REVISED).docx DOCX document
PL 009 TRA OPERATIONAL DATA STORE.docx DOCX document
PL 001 ELECTRONIC DATA INTERCHANGE (EDI).pdf PDF
Amendment #2.pdf PDF
PL 010 IDEA PART C DATA COLLECTION REGULATIONS.docx DOCX document
ATTM 005 HIPAA BAA.docx DOCX document
ATTM 016 Qestions and Answers.xlsx XLSX spreadsheet
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
TableTitle
Pricing Table AImplementation Phase Prices
Pricing Table BLabor Rates - Implementation
Pricing Table CLabor Rates - Operations
Pricing Table DModification Pools
Pricing Table EAnnual Operations Rates
Pricing Table FTurnover Phase Prices
Pricing Table GTotal 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:0
Payment Milestone No.Milestone NameMajor MilestoneContract Month of MilestoneFixed PricePayment PercentageAcceptance WithholdPayment Amount
1A$ -0%$ -$ -
2B$ -0%$ -$ -
3C*$ -0%$ -$ -
4D$ -0%$ -$ -
5E$ -0%$ -$ -
6F*$ -0%$ -$ -
7G$ -0%$ -$ -
8H$ -0%$ -$ -
9I$ -0%$ -$ -
10J*$ -0%$ -$ -
11K$ -0%$ -$ -
Add or remove lines as necessary
Actual Operational Start Date Month*0$ -10%$ -$ -
Subtotals$ -$ -$ -
System Acceptance Payment - 5% Withhold12$ -
Totals$ -10%$ -

B- Labor Rates - Implementation

Pricing Table B - Labor Rates - Implementation Phase
Contractor:Acme
Rates
Labor CategoryImplementation Phase Mod Pool Percentage of UseContract Year 1 RatesContract Year 2 RatesContract Year 3 RatesOption Year 1Option Year 2
A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
B0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
C0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
D0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
E0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
F0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
G0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
H0.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
Total Percentage Must Equal 100%0.00%
Annual Blended Rate$ - 0$ - 0$ - 0$ - 0$ - 0
Two Year Average Blended Rate$ - 0
For Evaluation Purposes - Two Year Average Blended Rate x 2,000 Hours$ - 0
Add or remove lines as necessary

C - Labor Rates Ops

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 RatesOption Year 1Option Year 2
A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
B0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
C0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
D0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
E0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
F0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
G0.00%$ - 0$ - 0$ - 0$ - 0$ - 0
H0.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
$ - 0$ - 0$ - 0$ - 0$ - 0
Total Percentage Must Equal 100%0.00%
Annual Blended Rate$ - 0$ - 0$ - 0$ - 0$ - 0
Three Year Average Blended Rate$ - 0
For Evaluation Purposes - Three Year Average Blended Rate x 4,000 Hours$ - 0
Add or remove lines as necessary

D - Modification Pools

Pricing Table D - Modification Pool
Contractor:Acme
Phase Modification Pool
$0

E - Operations

Pricing Table E - Annual Operations Rates
Contractor:Acme
Monthly Range of Active Beneficiaries (Members)Year 1Year 2Year 3Option Year 1Option Year 2
FromThroughLikelihoodMonthly FeeMonthly FeeMonthly FeeMonthly FeeMonthly FeeContract Total
14,5001%$ -$ -$ -$ -$ -$ -
4,5016,00094%$ -$ -$ -$ -$ -$ -
6,0017,5004%$ -$ -$ -$ -$ -$ -
7,5018,5001%$ -$ -$ -$ -$ -$ -
100%
Weighted Average Monthly Rate$ -$ -$ -$ -$ -$ -
Average Annual Rate$ -$ -$ -$ -$ -$ -
Amount Used for Cost Proposal Evaluation$ -
Amount Used for Contract Total Potential Value$ -

F - Turnover

Pricing Table F - Turnover PhaseM
Contractor:AcmeD
Contract Month to Begin Turnover80
Milestone/Deliverable NumberProposed Milestone/DeliverableMilestone (M)

or Deliverable (D) $ Amount Anticipated Invoice Date (Contract Month)

1A$ - 00
2B$ - 00
3C$ - 00
4D$ - 00
Total$ - 0

G - TCO

Pricing Table G - Total Cost of Ownership
Contractor:Acme
Pricing TableTotal Potential Value for 3 Base YearsTPV for 1st Option YearTPV for 2nd Option YearContract Total Potential ValueTotal Cost of Ownership
A - Implementation Phase$ - 0$ - 0$ - 0$ - 0$ - 0
D - Modification Pool$ - 0$ - 0$ - 0$ - 0$ - 0
E - Annual Operations Rates$ - 0$ - 0$ - 0$ - 0$ - 0
F - Turnover Phase$ - 0$ - 0$ - 0$ - 0
Total Not-to-Exceed Contract Value$ - 0$ - 0$ - 0$ - 0$ - 0
Cost to Maintain State's Project$ - 0
Total Cost of Ownership$ - 0

File details come from the government source that posted it. Updated .