Attachment_2_-_Cost-Price_Workbook.xlsx

XLSX spreadsheet 47 KB Posted

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

About this file

Attachment 2 - 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_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_2_-_Cost-Price_Workbook.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 2a

ATTACHMENT 2
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 MissionFFPJobN/A$ -
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
6Travel for MTC Site SurveyCostJobN/A$ 41,000
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
7MTC Installation ServicesFFPJobN/A$ -
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
8MTC EquipmentFFPLotN/A$ 6,500,000
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
9Travel for MTC Install ServicesCostJobN/A$ 123,000
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
10Over and AboveFFPJobN/A$ 1,000,000
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 MissionFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1006Travel for MTC Site SurveyCostJobN/A$ 44,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1007MTC Installation ServicesFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1008MTC EquipmentFFPLotN/A$ 13,000,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1009Travel for MTC Install ServiceCostJobN/A$ 132,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
1010Over & AboveFFPJobN/A$ 1,000,000
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 MissionFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2006Travel for MTC Site SurveyCostJobN/A$ 44,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2007MTC Installation ServicesFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2008MTC EquipmentFFPLotN/A$ 12,000,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2009Travel for Install ServiceCostJobN/A$ 130,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2010Over and AboveFFPJobN/A$ 1,000,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
2011CMRAFFPJob$ -$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3001Program ManagementFFPMonths$ -$ -
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 MissionFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3006Travel for MTC Site SurveyCostJobN/A$ 66,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3007MTC Installation ServicesFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3008MTC EquipmentFFPLotN/A$ 8,500,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3009Travel for MTC Install ServiceCostJobN/A$ 200,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
3010Over and AboveFFPJobN/A$ 1,000,000
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 MissionFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4006Travel for MTC Site SurveyCostJobN/A$ 56,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4007MTC Installation ServicesFFPJobN/A$ -
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4008MTC EquipmentFFPLotN/A$ 8,600,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4009Travel for Install ServiceCostJobN/A$ 167,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4010Over and AboveFFPJobN/A$ 1,000,000
OPTION
CLINDESCRIPTIONC TYPEQUANTITYUNIT PRICEAMOUNT
4011CMRAFFPJob$ -$ -
OPTION

Attachment 2b

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$41,000.001006$44,000.002006$44,000.003006$66,000.004006$56,000.00$251,000.00
7$0.001007$0.002007$0.003007$0.004007$0.00$0.00
8$6,500,000.001008$13,000,000.002008$12,000,000.003008$8,500,000.004008$8,600,000.00$48,600,000.00
9$123,000.001009$132,000.002009$130,000.003009$200,000.004009$167,000.00$752,000.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$7,664,000.00OPTION YEAR 1 TOTAL$14,176,000.00OPTION YEAR 2 TOTAL$13,174,000.00OPTION YEAR 3 TOTAL$9,766,000.00OPTION YEAR 4 TOTAL$9,823,000.00
TOTAL EVALUATED PRICE$54,603,000.00

Attachment 2c 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 CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Labor SubtotalLabor SubtotalLabor Subtotal

Labor Subtotal $ - 0 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 CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0

Labor Subtotal $ - 0 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 CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
$ - 0
$ - 0
$ - 0
$ - 0

Labor Subtotal $ - 0 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 CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
$ - 0

Labor Subtotal $ - 0 Labor Subtotal Labor Subtotal Labor Subtotal Labor Subtotal

CLIN 0005 MTC Site Survey MissionCLIN 1005 MTC Site Survey MissionCLIN 2005 MTC Site Survey MissionCLIN 3005 MTC Site Survey MissionCLIN 4005 MTC Site Survey Mission
Labor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0
Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0
Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0
AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0
Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0
Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0
Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0
CLIN 0007 MTC Installation ServicesCLIN 1007 MTC Installation ServicesCLIN 2007 MTC Installation ServicesCLIN 3007 MTC Installation ServicesCLIN 4007 MTC Installation Services
Labor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0Network Engineer (Intermediate)960$ - 0
Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0Furniture Designer1920$ - 0
Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0Post Design1920$ - 0
AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0AV Installation640$ - 0
Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0Network Installation640$ - 0
Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0Network Planning640$ - 0
Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0Labor Subtotal$ - 0
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 CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePriceLabor CategoryHoursFully Burdened Fixed Labor RatePrice
0$ - 0
Labor Subtotal$ - 0Labor SubtotalLabor SubtotalLabor SubtotalLabor Subtotal
Instructions:
1. Enter the labor category, hours and fully burdened labor rate then calculate the proposed price for each CLIN.
2. Enter the proposed price for each CLIN in Attachment 2a and 2b

Attachment 2d

Annual Software License Renewal Cost
CLINPriceM/HG&AFeeSubtotalIDIQ FFP CLINCost/PriceM/HG&AFeeTotal CLIN PriceIDIQ Cost CLINCost/PriceG&AFeeTotal CLIN Cost
Base Period RatesBase Period RatesBase Period Rates
00040008$ 6,500,000.00$ - 0$ - 0$ - 0$ 6,500,000.000006$ 41,000.00$ - 0$ - 0$ 41,000.00
Solarwinds$ - 0$ - 0$ - 0$ - 0
ODC CLIN TotalOption 1 RatesOption 1 Rates
1008$ 13,000,000.00$ - 0$ - 0$ - 0$ 13,000,000.001006$ 44,000.00$ - 0$ - 0$ 44,000.00
Option 1 Rates
1004Option 2 RatesOption 2 Rates
Solarwinds$ - 0$ - 0$ - 0$ - 02008$ 12,000,000.00$ - 0$ - 0$ - 0$ 12,000,000.002006$ 44,000.00$ - 0$ - 0$ 44,000.00
ODC CLIN Total
Option 3 RatesOption 3 Rates
Option 2 Rates3008$ 8,500,000.00$ - 0$ - 0$ - 0$ 8,500,000.003006$ 66,000.00$ - 0$ - 0$ 66,000.00
2004
Solarwinds$ - 0$ - 0$ - 0$ - 0Option 4 RatesOption 4 Rates
ODC CLIN Total4008$ 8,600,000.00$ - 0$ - 0$ - 0$ 8,600,000.004006$ 56,000.00$ - 0$ - 0$ 56,000.00
Option 3 RatesBase Period Rates
30040009$ 123,000.00$ - 0$ - 0$ 123,000.00
Solarwinds$ - 0$ - 0$ - 0$ - 0
ODC CLIN TotalOption 1 Rates
1009$ 132,000.00$ - 0$ - 0$ 132,000.00
Option 4 Rates
4004Option 2 Rates
Solarwinds$ - 0$ - 0$ - 0$ - 02009$ 130,000.00$ - 0$ - 0$ 130,000.00
ODC CLIN Total
Option 3 Rates
3009$ 200,000.00$ - 0$ - 0$ 200,000.00
Option 4 Rates
Instructions:4009$ 167,000.00$ - 0$ - 0$ 167,000.00
1. Enter the annual software license renewal 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 2c to establish the CLIN price.
3. Apply rates/factors to the provided cost/price values for each CLIN then enter the information on Attachment 2a.

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