Attach 17 - Proposal Cost Price Workbook 4-30-20 Updated.xls

XLS spreadsheet 85 KB Posted

Attached to
Cyber TRIDENT Federal contract opportunity
Solicitation number
W900KK-20-R-0001
Issued by
Department of the Army Materiel Command Contracting Command Orlando Contracting Center

About this file

This file contains pricing templates and instructions for a federal contract solicitation for Cyber Training, Readiness, Integration, Delivery and Enterprise Technology (Cyber TRIDENT) services. The templates require offerors to provide fully burdened labor rates for all proposed labor categories over an eight year period, along with fixed unit prices for infrastructure maintenance, support services, and software product development for the base period and seven one-year options. Pricing is also required for hardware devices, instrumentation, and other equipment. The solicitation is seeking to provide acquisition lifecycle optimization and evolution of the Program of Record for the Persistent Cyber Training Environment platform to support Army, Navy, Marine Corps, Air Force, National Guard, Reserves, and joint cyber training requirements.

View the file

Other files for this federal contract opportunity

Other files attached to Cyber TRIDENT, newest first.
File Type Posted
TO 0001-Order-SOW-CDRLs.pdf PDF
TO 0002-Order-SOW-CDRLs.pdf PDF
Slides - Industry Day - Pre-Solicitation Briefing Slides Contracts - 4-30-20.pptx PPTX presentation
DO 0003-Order-SOW-CDRLs.pdf PDF
CDRL_Base_SOW.pdf PDF
RFP - W900KK-20-R-0001 DRAFT 30 Apr 2020 Updated.pdf PDF
SOW - DO 3 CYBER TRIDENT DO 3 SOW - 29 Apr 2020 Updated.pdf PDF
SOW - TO 1 CYBER TRIDENT TO 1 SOW - 29 Apr 2020 Updated.pdf PDF
SOW - TO 2 CYBER TRIDENT TO 2 SOW - 29 Apr 2020 Updated.pdf PDF
Attach 1 - SOW - Base CYBER TRIDENT Base SOW - 29 Apr 2020 Updated.pdf PDF
Attach 18 - Past Perf Questionnaire - Cyber TRIDENT - 4-15-20 Updated.docx DOCX document
Attach 4 - RCS Price List - 4-24-20 Updated.docx DOCX document
Consolidated Industry Questions 1-200 4-30-2020 Posted (2).pdf PDF
Consolidated Industry Questions 1-200 4-30-2020 Posted.pdf PDF
Consolidated Industry Questions-Answer 1-74.pdf PDF
Q_A from Draft RFP.pdf PDF
Q-As -Cyber TRIDENT W900KK-20-R-0001 27 Mar 2020.pdf PDF
Distribution Agreement - Cyber TRIDENT Solicitation -Final 13 Mar 2020.pdf PDF
List of Attachments - 13 Mar 2020.pdf PDF
Attach 19 - Q-A Spreadsheet-12 Mar 2020.xlsx XLSX spreadsheet
Instructions for Obtaining Distribution D Document - 13 Mar 2020.pdf PDF
Statement of Work - DO 1 - Infrastructure and Maintenance.pdf PDF
Attach 14 - PCTE DD254.pdf PDF
Instructions to Obtain Distribution D Documents.docx DOCX document
Attach 16 - SF1408 - Pre-Award Suvey of Prospective Contractor Acctg System.pdf PDF
Attach 5 Small Business Participation Proposal Form.DOCX DOCX document
Attach 1 - Statement of Work - Basic Contract - Cyber TRIDENT.pdf PDF
00 Solicitation Attachment List.pdf PDF
Attach 18 - Past Perf Questionaire - Cyber TRIDENT.docx DOCX document
RFP - W900KK-20-R-0001 DRAFT 10 Mar 2020.pdf PDF
Attach 2 -Contract Labor Rates.docx DOCX document
Attach 15 - Pre-Award Survey of Prospective Contractor Acctg System Checklist.pdf PDF
Statement of Work - DO 2 - Integraton Factory.pdf PDF
Statement of Work -DO 3 - Platform Capability Production.pdf PDF
Show all 34

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

Cyber TRIDENT WORKBOOK - PRICING INSTRUCTIONS
See Section L of the Solicitation for full Instructions:
The Offeror shall provide a cost traceability matrix identifying linkage between CLIN unit cost in the Government provided spreadsheet and the Offeror’s pricing model.
Utilize this spreadsheet to populate the Offeror's Cost-Price Workbook.
Do not change the formulas. If there is an error, notify the Government POC as soon as possible.
Total Proposed Price' Tab: Read Only. Total proposed price will be automatically computed, BUT MUST BE VERIFIED AND VALIDATED BY OFFEROR.
IDIQ'Tab: For all CLINs, Offeror will populate the green highlighted cells with the pertinent cost or price information.
Tab A DO 0001, Tab B DO 0002, Tab C DO 0003, Attachment 03, and Attachment 04: For FFP, CPFF, and Cost CLINs, Offeror will complete unit prices (Green Cells) in each TO Tab of this spreadsheet. Extended prices will be automatically computed, BUT MUST BE VERIFIED AND VALIDATED BY OFFEROR.
Tab D Labor Rates: The offeror shall populate each cell with the pertinent information, including the labor rate for each proposed labor category. The Offeror can include additional Labor Categories, Company, Description of Work Performed, Education Level, and Minimum Years of Experience (as needed).
Tab D Labor Rate Cost Breakdown: This Tab shall include the fully burdened labor rates and individual indirect rates for each labor category proposed for each year of the contract and shall demonstrate the buildup of each fully burdened rate by element. The proposed fully burdened labor rates (including profit for FFP and excluding fee for CPFF) will be incorporated into the contract for use as not-to-exceed ceiling rates. Information that is provided but determined to be insufficient may result in an adverse assessment of an offeror’s proposal. The Offeror can include additional Labor Categories as needed.
If the Offeror finds any errors in the computations, they must notify the Contracting Team immediately for resolution.

&RW900KK-19-R-0079

Attachment L5

Total Proposed Price

TOTAL EVALUATED PRICE
Amount
ID/IQ$0.00
Tab A DO 0001$0.00
Tab B DO 0002$0.00
Tab C DO 0003$0.00
Attachment 003$0.00
Attachment 004$0.00
Total Proposed Price$0.00

&CTOTAL ESTIMATED PRICE

(TEP)&RW900KK-

Attachment L5

Basic IDIQ

Pricing Template
BASIC IDIQ
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
1Post Award Conference1Each$0
FFP
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
2Initial Contract Data Requirements1Each$0
FFP1. Risk Management Plan IAW Basic SOW-2020-011 Section 3.1.7, CDRL A0011Each
2. System Eng Mgmt Plan, IAW Basic SOW-2020-011, Section XXXX, CDRL B0011Each
3. Operations Sec Plan, IAW SOW2020-011, Section 3.4.6, CDRL B0021Each
4. Systems Security Plan, IAW SOW-2020-011, Sec 3.4.7.11, CDRL B0031Each
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
12Completion of Transition In Activities1Each$0$0
FFP
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
13Transition In - SCIF1Each$0$0
FFP
Proposed IDIQ Total$0

&RW900KK-18-R-0007

Attachment L8

Tab A DO 0001

Pricing Template
DO 0001
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
xx03Infrastructure and Maintenance93Months$0
FFPContract Year 1 - Monthly Unit Price9Months
Contract Year 2 - Monthly Unit Price12Months
Contract Year 3 - Monthly Unit Price12Months
Contract Year 4 - Monthly Unit Price12Months
Contract Year 5 - Monthly Unit Price12Months
Contract Year 6 - Monthly Unit Price12Months
Contract Year 7 - Monthly Unit Price12Months
Contract Year 8 - Monthly Unit Price12Months
OPTION
Proposed DO 0001 Total$0

&RW900KK-18-R-0007

Attachment L8

Tab B DO 0002

Pricing Template
DO 0002
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
xx10Support Services - Year 11LOT$0
CPFFFixed Fee
Support Services - Year 21LOT$0
Fixed Fee
Support Services - Year 31LOT$0
Fixed Fee
Support Services - Year 41LOT$0
Fixed Fee
Support Services - Year 51LOT$0
Fixed Fee
Support Services - Year 61LOT$0
Fixed Fee
Support Services - Year 71LOT$0
Fixed Fee
Support Services - Year 81LOT$0
Fixed Fee
Proposed DO 0002 Total$0

&RW900KK-18-R-0007

Attachment L8

Tab C DO 0003

Pricing Template
DO 0003
CLINDESCRIPTIONQUANTITYU/IUNIT PRICEAMOUNT
xx06Software Products Development - Year 11LOT$0
CPFFFixed Fee
Software Products Development - Year 21LOT$0
Fixed Fee
Software Products Development - Year 31LOT$0
Fixed Fee
Software Products Development - Year 41LOT$0
Fixed Fee
Software Products Development - Year 51LOT$0
Fixed Fee
Software Products Development - Year 61LOT$0
Fixed Fee
Software Products Development - Year 71LOT$0
Fixed Fee
Software Products Development - Year 81LOT$0
Fixed Fee
Proposed DO 0003 Total$0

Attachment 03

Attachment 003
Part DescriptionPart NumberQuantityUnit Prices
Environmental Monitoring
APC Net Botz Rack MonitorNetBotz 5701
Rack SensorNBPD01501
Temp/Humidity SensorAP9335TH1
Fluid SensorNBES03011
Door SensorNBES03031
Smoke DetectorNBS03071
Alarm BeaconAP93241
Hardware Devices
Wan SwitchWS-C3850-48T-S1
Storage/Fiber DrawerN/A1
KMMDKMMLED185-G011
KVMMPU2032DAC-0011
Time ServerMicrosemi S6501
PowerEdge FX2 ChassisPowerEdge FX21
PowerEdge FC640 blade serverFC6401
RouterASR1001-HX1
Management SwitchWS-C3850-48U-E1
Management ServerPowerEdge VRTX1
Nexus Switch StorageN5696-B-24Q1
Nexus Switch ComputeN5696-B-24Q1
Storage ControllerFAS90001
Storage Disk ShelfDS224C1
Instrumentation SwitchWS-C3850-48T-L1
Patch PanelC6AFP70S-481
Compute SwitchWS-C3850-24T-L1
F5 BIG-IP iSeries i5820-DF Load Balancing Device Best BundleF5-BIG-BT-I5820-DF1
F5 Power SupplyF5-UPG-AC-I5XXX1
V CBL MGR Netshelter SX 750MM Wide 42UAR7580A1
Vertical PDUs
Rack PDU (C20 Plugs Added)AP88661
Rack PDU (C14 Plugs Only)AP88671
Avocent Adapters
MergePoint Unity Serial (LAN)MPUIQ-SRL1
Server Interface Module (VGA)MPUIQ-VMCHS1
Amperor Power Supply (NetApp)ADP18AC-06-C81
NetApp PDU Power AdapterPS2POWER2301
Mini-SAS Cables
.5M Mini-SAS CableSAS-4444-05M1
2M Mini-SAS CableSAS-4444-2M1
Total

Attachment 04

Attachment 004
Year 1QtyUnit PriceExtended Price
RCS1$0.00
RCS2$0.00
Year 2QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 3QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 4QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 4QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 6QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 7QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Year 8QtyUnit PriceDelivery Schedule
RCS1$0.00
RCS2$0.00
Total$0.00

Tab D Labor Rates

Offeror's Name:
The offeror shall populate each cell with the pertinent information, including the labor rate for each proposed labor category. The Offeror can include additional information such as Company, Offeror Equivilant Category, Description of Work Performed, Education Level, and Minimum Years of Experience (as needed).
Labor CategoryCompanyDescription of Work PerformedEducation Level
(or Equivalent Experience)*Minimum Years of ExperienceYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8
Instructions:Provide the Labor Category Title, Description, and Fully Burdened Labor rates proposed for CPFF CLINs for each year
Note 1: Fully Burdened FFP rates shall include profit and Fully Burdened CPFF rates shall exclude fee

Tab D Labor Rate Cost Breakdown

The offeror will input their base rate for each labor category proposed and then apply indirect rates to demonstrate the development of a fully burdened rate through profit for each category as applicable. The offeror can adjust and expand this worksheet as needed to complete the calculation, and shall demonstrate FFP rates inclusive of profit and CPFF rates exclusive of fee.
Offeror's Name:
Fully Burdened Rate Build-up (Year 1)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 2)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 3)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 4)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 5)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 6)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 7)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal
Fully Burdened Rate Build-up (Year 8)
Labor CategoryBase Labor RateFringe RateFringe DollarsSub-TotalOverhead RateOverhead DollarsSub-TotalG&A RateG&A DollarsSub-TotalSubK OH RateSubK OH DollarsSub-TotalProfitTotal

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