Attachement 003 - TRIOSS Pricing Workbook (Amendment 01).xlsx

XLSX spreadsheet 33 KB Posted

Attached to
TRAINING INSTRUCTOR OPERATOR SERVICES SUPPORT II
Solicitation number
W900KK-27-R-A0003
Issued by

About this file

This is a pricing workbook template for the TRIOSS II (Training Instructor Operator Services Support II) contract, which is a Firm Fixed Price Mandatory Minimum Staffing Baseline (MMSB) contract for instructor and operator support services at Army Military Science and Tactics Centers (MSTCs) across CONUS and OCONUS locations. The base year pricing structure includes CLIN X001 for TRIOSS Services at $746,240.00 (FFP) and CLIN X002 for Travel costs at $12,000.00, for a total base year evaluated price of $758,240.00. The contract includes four one-year option periods with no change to the travel costs ($12,000.00 annually) and a six-month -8 option period with $6,000.00 in travel costs, resulting in a total contract value of $806,240.00 across all periods.

The pricing workbook is structured to accommodate Mandatory Minimum Staffing Baseline (MMSB) labor requirements across multiple installation locations, including Fort Atterbury (Indiana), Camp Ripley (Minnesota), and numerous other military installations nationwide and overseas. Part 1 requires contractors to specify FTEs by labor category (Paramedic and EMT positions) with corresponding fully burdened labor rates (FBLR), total hours, and pricing. Part 2 allows for "Above & Beyond" management and support labor costs, while Part 3 captures monthly travel expenses. The workbook includes a labor rate buildup section demonstrating how to calculate FBLR from direct labor rates through fringe benefits, overhead, G&A, and profit markups. The example shows base labor rates ranging from $25.00 to $50.00 per hour, with fully burdened rates between $42.90 and $85.80 after all cost factors are applied. Contractors must complete separate sections for each contract period and populate staffing and pricing details specific to their proposed approach for delivering continuous instructor and operator support services.

View the file

Other files

File Type Posted
Solicitation - W900KK27RA003 - Amendment 02.pdf PDF
Attachment 005 - Sections L (Amendment 02).pdf PDF
Attachment 001PWS TRIOSS II (Amendment 02).pdf PDF
Attachment 006 - Sections M (Amendment 02).pdf PDF
Attachment 009 -Answers to the TRIOSS RFP (Amendment 02).xlsx XLSX spreadsheet
Attachment 009 -Answers to the TRIOSS RFP.xlsx XLSX spreadsheet
Attachment 006 - Sections M (Amendment 1).pdf PDF
Attachment 002 QASP_TRIOSS II (Amendment 01).pdf PDF
Attachment 005 - Sections L (Amendment 1).pdf PDF
Attachment 004 Contract Data Requirement List (CDRL) TRIOSS II (Amendment 01).pdf PDF
Solicitation - W900KK27RA003 (Amendment 01).pdf PDF
Attachment 001 PWS TRIOSS II (Amendment 1).pdf PDF
Attachment 007 List of Collective Bargaining Agreement and Wage Determinations (Amendment 1).pdf PDF
Solicitation - W900KK27RA003.pdf PDF
Attachment 004 - Contract Data Requirement List (CDRL)_TRIOSS II.pdf PDF
Attachment 002 - QASP.pdf PDF
Attachement 003 - TRIOSS EXCEL Workbook.xlsx XLSX spreadsheet
Attachment 001 - PWS_TRIOSS II.docx DOCX document
Attachment 008 - Monthly Invoicing Reconciliation.xlsx XLSX spreadsheet
Attachment 006 - Sections M.docx DOCX document
Attachment 005 - Sections L.docx DOCX document
Attachment 009 - Questions for the TRIOS II RFP.xlsx XLSX spreadsheet
Attachment 007 List of Collective Bargaining Agreement and Wage Determinations.pdf PDF
Show all 23

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

Summary

Total Evaluated Price (TEP) Summary
PeriodCLIN X001 - TRIOSS Services (FFP)CLIN X002 - Travel (Cost)Total Period Price
Base Year$ 746,240.00$ 12,000.00$ 758,240.00**NOTE** Numbers entered for CLIN 1 are for an example.
Option Year 1$ - 0$ 12,000.00$ 12,000.00
Option Year 2$ - 0$ 12,000.00$ 12,000.00
Option Year 3$ - 0$ 12,000.00$ 12,000.00
Option Year 4$ - 0$ 12,000.00$ 12,000.00
Total Contract Value (All Years minus the -8)$ 746,240.00$ 60,000.00$ 806,240.00

Base Year

CLIN 0001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total Hours

(1992hrs equals

1 FTE)Total Price
CP Atterbury, INParamedic1$ 45.00Y1992$ 89,640.00
CP Atterbury, INEMT1$ 42.00y1992$ 83,664.00**NOTE** Numbers entered and labor catagories entered are for examples only
CP Atterbury, INEMT1$ 42.00y1992$ 83,664.00It is up to the Offeror to fill out the information based on the required MMSB,
CP Atterbury, INEMT1$ 42.00y1992$ 83,664.00and the Offeror's costs.
CP Ripley, MNParamedic1$ 51.00N800$ 40,800.00
CP Ripley, MNParamedic$ 52.50N1192$ 62,580.00
CP Ripley, MNEMT1$ 48.00N800$ 38,400.00
CP Ripley, MNEMT$ 49.50N1192$ 59,004.00
CP Ripley, MNEMT1$ 47.00N800$ 37,600.00
CP Ripley, MNEMT$ 48.50N1192$ 57,812.00
CP Ripley, MNEMT1$ 47.00N800$ 37,600.00
CP Ripley, MNEMT$ 48.50N1192$ 57,812.00
CP Humphreys, KoreaParamedic$ - 0
CP Humphreys, KoreaEMT$ - 0
CP Williams, UTParamedic$ - 0
CP Williams, UTEMT$ - 0
FT Bliss, TXParamedic$ - 0
FT Bliss, TXEMT$ - 0
FT Bragg, NCParamedic$ - 0
FT Bragg, NCEMT$ - 0
FT Campbell, KYParamedic$ - 0
FT Campbell, KYEMT$ - 0
FT Carson, COParamedic$ - 0
FT Carson, COEMT$ - 0
FT Dix, NJParamedic$ - 0
FT Dix, NJEMT$ - 0
FT Drum, NYParamedic$ - 0
FT Drum, NYEMT$ - 0
FT Hood, TX (A)Paramedic$ - 0
FT Hood, TX (A)EMT$ - 0
FT Hood, TX (B)Paramedic$ - 0
FT Hood, TX (B)EMT$ - 0
FT Indiantown Gap, PAParamedic$ - 0
FT Indiantown Gap, PAEMT$ - 0
FT Lewis, WAParamedic$ - 0
FT Lewis, WAEMT$ - 0
FT McCoy, WIParamedic$ - 0
FT McCoy, WIEMT$ - 0
FT Riley, KSParamedic$ - 0
FT Riley, KSEMT$ - 0
FT Stewart, GAParamedic$ - 0
FT Stewart, GAEMT$ - 0
FT Wainwright, AKParamedic$ - 0
FT Wainwright, AKEMT$ - 0
Papago, AZParamedic$ - 0
Papago, AZEMT$ - 0
Schofield Barracks, HIParamedic$ - 0
Schofield Barracks, HIEMT$ - 0
Vilseck, GermanyParamedic$ - 0
Vilseck, GermanyEMT$ - 0
MEDCoE, JBSAParamedic$ - 0
CP DodgeParamedic$ - 0
CP DodgeEMT$ - 0
Ft. BenningParamedic$ - 0
Ft. BenningEMT$ - 0
CP. ShelbyParamedic$ - 0
CP. ShelbyEMT$ - 0
Total FTEs8
Part 1 Sub Total$ 732,240.00
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price**NOTE** Numbers entered and labor catagories entered are for examples only
e.g. Program Manager111621162It is up to the Offeror to fill out the information based on the required MMSB,
e.g. Site Lead411624648and the Offeror's costs.
Total$ - 0
ExpensesTotal Price
Certification Fees$ 12,000.00**NOTE** Numbers entered are for examples only
DBA Insurance$ 2,000.00
Subtotal$14,000.00Part 2 Sub Total$14,000.00
Part 3
CLIN 0002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.0012$12,000.00
Totals for Base Year
Total Price - CLIN 0001 Monthly Operational Support Services (FFP)$746,240.00**NOTE** Numbers entered are for examples only
Total Price - CLIN 0002 Travel (Cost-No-Fee)$12,000.00
Total Evaluated
Period Price$758,240.00

Option Year 1

CLIN 1001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total HoursTotal Price
Total FTEs0
Part 1 Sub Total$ - 0
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price

Total $ - 0

Expenses Total Price

Subtotal $0.00 Part 2 Sub Total $0.00

Part 3
CLIN 1002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.0012$12,000.00
Totals for Option Period 1
Total Price - CLIN 1001 Monthly Operational Support Services (FFP)$0.00
Total Price - CLIN 1002 Travel (Cost-No-Fee)$12,000.00
Total Evaluated
Period Price$12,000.00

Option Year 2

CLIN 2001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total HoursTotal Price
Total FTEs0
Part 1 Sub Total$ - 0
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price

Total $ - 0

Expenses Total Price

Subtotal $0.00 Part 2 Sub Total $0.00

Part 3
CLIN 2002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.0012$12,000.00
Totals for Option Period 2
Total Price - CLIN 2001 Monthly Operational Support Services (FFP)$0.00
Total Price - CLIN 2002 Travel (Cost-No-Fee)$12,000.00
Total Evaluated
Period Price$12,000.00

Option Year 3

CLIN 3001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total HoursTotal Price
Total FTEs0
Part 1 Sub Total$ - 0
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price

Total $ - 0

Expenses Total Price

Subtotal $0.00 Part 2 Sub Total $0.00

Part 3
CLIN 3002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.0012$12,000.00
Totals for Option Period 3
Total Price - CLIN 3001 Monthly Operational Support Services (FFP)$0.00
Total Price - CLIN 3002 Travel (Cost-No-Fee)$12,000.00
Total Evaluated
Period Price$12,000.00

Option Year 4

CLIN 4001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total HoursTotal Price
Total FTEs0
Part 1 Sub Total$ - 0
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price

Total $ - 0

Expenses Total Price

Subtotal $0.00 Part 2 Sub Total $0.00

Part 3
CLIN 4002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.0012$12,000.00
Totals for Option Period 4
Total Price - CLIN 4001 Monthly Operational Support Services (FFP)$0.00
Total Price - CLIN 4002 Travel (Cost-No-Fee)$12,000.00
Total Evaluated
Period Price$12,000.00

- 8 Option (6 months)

CLIN 5001 - TRIOSS Services
Part 1: Mandatory Minimum Staffing Baseline (MMSB) Labor
LocationLabor CategoryMMSB FTEsFBLRFull Year (Y/N)Total HoursTotal Price
Total FTEs0
Part 1 Sub Total$ - 0
Part 2: 'Above & Beyond' Labor (Management & Support)
LocationLabor CategoryProposed FTEsAnnual Hours per FTETotal HoursFBLRTotal Price

Total $ - 0

Expenses Total Price

Subtotal $0.00 Part 2 Sub Total $0.00

Part 3
CLIN 5002 - Travel
DescriptionPriceNumber of MonthsTotal
CLIN X002 - Travel (Govt. Plug Number)$1,000.006$6,000.00
Totals for -8 Option
Total Price - CLIN 5001 Monthly Operational Support Services (FFP)$0.00
Total Price - CLIN 5002 Travel (Cost-No-Fee)$6,000.00
Total
Period Price$6,000.00

Labor Rate Buildup

PeriodLabor CategoryDirect Labor RateFringe Rate (%)Fringe AmountSubtotal (DLR+Fringe)Overhead Rate (%)Overhead AmountSubtotal (DLR+Fringe+OH)G&A Rate (%)G&A AmountCost Base (Total Cost)Profit Rate (%)Profit AmountFully Burdened Labor Rate (FBLR)
Base Yeare.g. Paramedic (FT Bliss)$25.000.35$8.75$33.750.1$3.38$37.130.08$2.97$40.100.07$2.81$42.90
Base Yeare.g. Program Manager$50.000.35$17.50$67.500.1$6.75$74.250.08$5.94$80.190.07$5.61$85.80
***NOTE***
For full work up on Labor Rates, Offeror can use this one Tab and list all labor catagories down through all of the period of performances or use multiple TABs to divide each yearly period.
If there are muliple CBA rates for one year of performance due to the timing of the agreement, then both labor rates should be listed for the one position. Offeror can list the dates in the Labor Category Column (ex. 1 Mar - 17 Dec) or create a new column with the dates.

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