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

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 009 BABYNET PRICING TABLES BLANK.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:6
Payment Milestone No.Milestone NameMajor MilestoneContract Month of MilestoneFixed PricePayment PercentageAcceptance WithholdPayment Amount
1A1$ 17,500.007%$ 875.00$ 16,625.00
2B2$ 25,000.0010%$ 1,250.00$ 23,750.00
3C*3$ 32,500.0013%$ 1,625.00$ 30,875.00
4D4$ 42,500.0017%$ 2,125.00$ 40,375.00
5E5$ 32,500.0013%$ 1,625.00$ 30,875.00
6F*5$ 25,000.0010%$ 1,250.00$ 23,750.00
7G6$ 17,500.007%$ 875.00$ 16,625.00
8H6$ 12,500.005%$ 625.00$ 11,875.00
9I8$ 5,000.002%$ 250.00$ 4,750.00
10J*8$ 7,500.003%$ 375.00$ 7,125.00
11K9$ 7,500.003%$ 375.00$ 7,125.00
Add or remove lines as necessary
Actual Operational Start Date Month*6$ 25,000.0010%$ 1,250.00$ 23,750.00
Subtotals$ 250,000.00$ 12,500.00$ 237,500.00
System Acceptance Payment - 5% Withhold18$ 12,500.00
Totals$ 250,000.00100%$ 250,000.00

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
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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 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 CategoryReplacement Phase Mod Pool Percentage of UseContract Year 1 RatesContract Year 2 RatesContract Year 3 RatesOption Year 1Option Year 2
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
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 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 1Year 2Year 3Option Year 1Option Year 2
FromThroughLikelihoodMonthly FeeMonthly FeeMonthly FeeMonthly FeeMonthly FeeContract Total
14,5001%$ 22,500$ 20,000$ 20,000$ 20,000$ 20,000$ 102,500
4,5016,00094%$ 25,000$ 22,500$ 22,500$ 22,500$ 22,500$ 115,000
6,0017,5004%$ 27,500$ 25,000$ 25,000$ 25,000$ 25,000$ 127,500
7,5018,5001%$ 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 PhaseM
Contractor:AcmeD
Contract Month to Begin Turnover80
Milestone/Deliverable NumberProposed Milestone/DeliverableMilestone (M)

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

1A$ 1,000.0037
2B$ 2,000.0038
3C$ 3,000.0039
4D$ 4,000.0040
Total$ 10,000.00

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$ 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 .