Attachment_2_-_Cost-Price_Workbook.xlsx

XLSX spreadsheet 53 KB Posted

Attached to
Battle Command Training Capability - Equipment Support (BCTC-ES) Competition
Solicitation number
W900KK-17-R-0013
Issued by

About this file

Cost-Price Workbook

View the file

Other files

File Type Posted
Attachment_4_-_Scenario_Cost-Price_Workbook_(Amend_002).xlsx XLSX spreadsheet
W900KK-17-R-0013_Conformed_Copy_through_Amend_0002.pdf PDF
Offeror_Questions_and__Government_Answers_for_Amend_0002.pdf PDF
Attachment_2_-_Cost-Price_Workbook_(Amend_0002).xlsx XLSX spreadsheet
Attachment_9_-_PAST_PERFORMANCE_EVALUATION_QUESTIONNAIRE_FORM_(Amend_0002).docx DOCX document
Attachment_8_Performance_Work_Statement_(Amend_0002).docx DOCX document
Attachment_10_-_Draft_Authorization_to_use_FSS_and_Army_CHESS_(Amend_0002).doc DOC document
W900KK-17-R-0013_Amend_0002.pdf PDF
Attachment_9_-_PAST_PERFORMANCE_EVALUATION_QUESTIONNAIRE_FORM.docx DOCX document
W900KK-17-R-0013_Amendment_0001.pdf PDF
Attachment_2_-_Cost-Price_Workbook.xlsx XLSX spreadsheet
Attachment_6_-_Question_Comment_Form.xlsx XLSX spreadsheet
Exhibit_A_-_CDRLs.pdf PDF
Attachment_3_-_Fixed_Fully_Burdened_Labor_Rate_Buildup.xls XLS spreadsheet
W900KK-17-R-0013_Released_4_April_2017.pdf PDF
Attachment_4_-_Scenario_Cost-Price_Workbook.xlsx XLSX spreadsheet
Attachment_1_-_BCTC-ES_FFE_Packages_S_M_L_MTC.xlsx XLSX spreadsheet
Attachment_7_Security_Form_DD254.pdf PDF
Attachment_5_-_Data_Item_Transmittal_Form.doc DOC document
Attachment_8_Performance_Work_Statement.pdf PDF
W900KK17R0013DRFPQuestions.xlsx XLSX spreadsheet
Official_Draft_Solicitation_W900KK-17-R-0013_BCTC-ES_121316.docx DOCX document
Attachment_3_-_Fixed_Fully_Burdened_Labor_Rate_Buildup.xls XLS spreadsheet
Attachment_1_-_BCTC-ES_FFE_Packages_S,_M,_L_MTC.xlsx XLSX spreadsheet
Attachment_4_-_Scenario_Cost-Price_Workbook.xlsx XLSX spreadsheet
Show all 25

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

Attachment 5a

ATTACHMENT 5
CLINDESCRIPTIONC TYPEQUANTITYUnit PriceAMOUNT
1Program ManagementFFPMonths
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2RWIS Help Desk & IA SupportFFPMonths
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3Video Telecon Help Desk SupportFFPMonths
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4Annual COTS SW License RenewalsFFPYear
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
5MTC Site Survey MissionFFPJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
6Travel for MTC Site SurveyCostJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
7MTC Installation ServicesFFPJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
8MTC EquipmentFFPLot
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
9Travel for MTC Install ServicesCostJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
10Over and AboveFFPJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
11CMRAFFPJob
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1001Program ManagementFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1002RWIS Help Desk & IA SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1003Video Telecon Help Desk SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1004Annual COTS SW License RenewalFFPYear
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1005MTC Site Survey MissionFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1006Travel for MTC Site SurveyFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1007MTC Installation ServicesFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1008MTC EquipmentFFPLot
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1009Travel for MTC Install ServiceCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1010Over & AboveFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1011CMRAFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2001Program ManagementFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2002RWIS Help Desk & IA SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2003Video Telecon Help Desk SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2004Annual COTS SW License RenewalFFPYear
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2005MTC Site Survey MissionFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2006Travel for MTC Site SurveyCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2007MTC Installation ServicesFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2008MTC EquipmentFFPLot
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2009Travel for Install ServiceCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2010Over and AboveFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2011CMRAFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3001Program ManagementFFPMolnths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3002RWIS Help Desk & IA SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3003Video Telcon Hwelp Desk SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3004Annual COTS SW License RenewalFFPYear
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3005MTC Site Survey MissionFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3006Travel for MTC Site SurveyCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3007MTC Installation ServicesFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3008MTC EquipmentFFPLot
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3009Travel for MTC Install ServiceCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3010Over and AboveFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3011CMRAFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYCOSTAMOUNT
4001Program ManagementFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4002RWIS Help Desk & IA SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4003Video Telecon Help Desk SupportFFPMonths
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4004Annual COTS SW License RenewalFFPYear
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4005MTC Site Survey MissionFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4006Travel for MTC Site SurveyCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4007MTC Installation ServicesFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4008MTC EquipmentFFPLot
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4009Travel for Install ServiceCostJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4010Over and AboveFFPJob
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4011CMRAFFPJob
OPTION

Attachment 5b

BASE PRICING WORKBOOK
BASE YEAROPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4
Firm Fixed Price
CLINPriceCLINPriceCLINPriceCLINPriceCLINPriceCLIN AGGREGATE TOTAL
1$0.001001$0.002001$0.003001$0.004001$0.00$0.00
2$0.001002$0.002002$0.003002$0.004002$0.00$0.00
3$0.001003$0.002003$0.003003$0.004003$0.00$0.00
4$0.001004$0.002004$0.003004$0.004004$0.00$0.00
5$0.001005$0.002005$0.003005$0.004005$0.00$0.00
6$0.001006$0.002006$0.003006$0.004006$0.00$0.00
7$0.001007$0.002007$0.003007$0.004007$0.00$0.00
8$0.001008$0.002008$0.003008$0.004008$0.00$0.00
9$0.001009$0.002009$0.003009$0.004009$0.00$0.00
10$1,000,000.001010$1,000,000.002010$1,000,000.003010$1,000,000.004010$1,000,000.00$5,000,000.00
11$0.001011$0.002011$0.003011$0.004011$0.00$0.00
BASE YEAR TOTAL$1,000,000.00OPTION YEAR 1 TOTAL$1,000,000.00OPTION YEAR 2 TOTAL$1,000,000.00OPTION YEAR 3 TOTAL$1,000,000.00OPTION YEAR 4 TOTAL$1,000,000.00
TOTAL EVALUATED PRICE$5,000,000.00

Attachment 5c Offeror's Name: "Offeror"

FULLY BURDENED LABOR RATES
Labor CategoryBase Labor RateOption Year 01 Labor RateOption Year 02 Labor RateOption Year 03 Labor RateOption Year 04 Labor Rate
Principle Management
Program Analysts/Specialist
Program Management
Project Coordinator
Project Data Management
VTC Field Engineer
VTC Customer Support Engineer
IT Project Management
AV Planning
AV Installation
Network Engineer
Network Installation
Network Planning
Furniture/Interior Designer
Post Design

It is the Government's Intent to included all proposed Labor Rates for each applicable year into the contract as 'Ceiling Labor Rates' at time of award. Offeror's shall fill in any additional rates they may utilize as appropriate.

Attachment 5d Offeror's Name: "Offeror"

Rates (and FCCM Factors)BaseOption
Year 01Option
Year 02Option
Year 03Option
Year 04Description and CalculationDefinition and Allocation Base
5.00%5.10%5.20%5.30%5.40%These rates are samples to show formula breakout.*
Labor Fringes
Engineering Overhead
Manufacturing Overhead
Material Handing
Subcontractor Handling
G&A Expenses
Proposed Fee
Instructions:
1. If any of the rates/factors are not used in your estimating/accounting systems, leave the yearly blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base".
2. Each Offeror shall supply their applicable rates for Base and all Four Option Years and a description and/or calculation of how their rates/factors were developed. That information can be included either below or elsewhere in your Cost/Price Volume.
3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment such as (for G&A expenses): Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ).
4. If you have additional rates/factors in your estimating/accounting systems, you can add rows as needed.

Attachment 5e Labor Calculations for FFP CLIN Labor Calculations for FFP CLIN Labor Calculations for FFP CLIN Labor Calculations for FFP CLIN Labor Calculations for FFP CLIN

CLIN 0001 Program ManagementCLIN 1001 Program ManagementCLIN 2001 Program ManagementCLIN 3001 Program ManagementCLIN 4001 Program Management
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0002 RWIS Help Desk, IA SupportCLIN 1002 RWIS Help Desk, IA SupportCLIN 2002 RWIS Help Desk, IA SupportCLIN 3002 RWIS Help Desk, IA SupportCLIN 4002 RWIS Help Desk, IA Support
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0003 VTC Help Desk SupportCLIN 1003 VTC Help Desk SupportCLIN 2003 VTC Help Desk SupportCLIN 3003 VTC Help Desk SupportCLIN 4003 VTC Help Desk Support
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0004 Annual COTS Software License SupportCLIN 1004 Annual COTS Software License SupportCLIN 2004 Annual COTS Software License SupportCLIN 3004 Annual COTS Software License SupportCLIN 4004 Annual COTS Software License Support
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0005 MTC Site Survey MissioinCLIN 0005 MTC Site Survey MissioinCLIN 0005 MTC Site Survey MissioinCLIN 0005 MTC Site Survey MissioinCLIN 0005 MTC Site Survey Missioin
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0007 MTC Installation ServicesCLIN 0007 MTC Installation ServicesCLIN 0007 MTC Installation ServicesCLIN 0007 MTC Installation ServicesCLIN 0007 MTC Installation Services
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice

Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0011 Contractor Manpower Reporting ApplicationCLIN 1011 Contractor Manpower Reporting ApplicationCLIN 2011 Contractor Manpower Reporting ApplicationCLIN 3011 Contractor Manpower Reporting ApplicationCLIN 4011 Contractor Manpower Reporting Application
Labor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePriceLabor CategoryHoursLabor RatePrice
Labor SubtotalLabor SubtotalLabor SubtotalLabor SubtotalLabor Subtotal
Instructions:
1. Enter the labor categroy, hours and fully burdened labor rate then calculate the proposed price for each CLIN.
2. Enter the proposed price for each CLIN in Attachment 9a and 9b

Attachment 5f

Annual Software License Renewal Cost
CLINPriceM/HG&AFeeSubtotalIDIQ FFP CLINCost/PriceM/HG&AFeeTotal CLIN PriceIDIQ Cost CLINCost/PriceG&ATotal CLIN Cost
Offeror's RatesOfferor's RatesOfferor's Rates
00040008$ 7,932,855.000006$ 40,769.00
RWIS
Solarwinds1008$ 12,783,220.001006$ 43,677.00
ODC CLIN Total
10042008$ 11,280,501.002006$ 43,329.00
RWIS
Solarwinds3008$ 8,417,442.003006$ 65,947.00
ODC CLIN Total
20044008$ 8,585,791.004006$ 55,537.00
RWIS
Solarwinds0009$ 122,307.00
ODC CLIN Total
30041009$ 131,031.00
RWIS
Solarwinds2009$ 129,987.00
ODC CLIN Total
40043009$ 197,841.00
RWIS
Solarwinds4009$ 166,611.00
ODC CLIN Total
Instructions:
1. Enter the annual software license renewals cost then apply rates/factors to arrive at the Subtotal for each software license.
2. Total each CLIN then combine the total with the labor cost from Attachment 9d to establish the CLIN price.
3. Apply rates/factors to the provided cost/price values for each CLIN then enter the information on Attachment 5a.

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