Attachment_0009_Resource_Distribution_Table.xlsx
XLSX spreadsheet 58 KB Posted
- Solicitation number
- W56HZV19R0043
About this file
This document contains a request for proposal for the Team Armor Partnership program. The contractor shall receive, store, issue, and repair line and shop replacement units for M1 Abrams, M2/M3 Bradley, and M104 Wolverine assets. Repair activities shall be conducted in accordance with technical manuals or original equipment manufacturer standards. The contractor shall utilize the Logistics Modernization Program system to manage repair assets. The contractor shall perform work in a government-provided facility at Fort Hood, Texas. A question and answer period is available until March 5, 2020, and a pre-proposal conference is anticipated.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment_0005_RFP_TAP_W56HZV-19-R-0043.pdf | ||
| Amendment_0004_RFP_TAP_W56HZV-19-R-0043.pdf | ||
| Amendment_0003_RFP_TAP_W56HZV-19-R-0043.pdf | ||
| Amendment_0003_TAP_CSDR_Plan.xls | XLS spreadsheet | |
| Amendment_0003_TAP_ Pricing Workbook.xlsx | XLSX spreadsheet | |
| Amendment_0002_RFP_TAP_W56HZV-19-R-0043.pdf | ||
| Attachment_0011_TACOM_OPSEC_PLAN.pdf | ||
| Amendment 0001_Attachment_0001_TAP_GFP_List.xlsx | XLSX spreadsheet | |
| Amendment 0001 RFP - TAP W56HZV-19-R-0043.pdf | ||
| Attachment 0004_TAP_Pricing_Workbook.xlsx | XLSX spreadsheet | |
| Attachment 0003_TAP_TrackerLite_System_Instructions.pdf | ||
| Attachment_0001_TAP_GFP_List.xlsx | XLSX spreadsheet | |
| Attachment_0008_TAP_CSDR_Plan.xls | XLS spreadsheet | |
| RFP_TAP_W56HZV-19-R-0043.pdf | ||
| Attachment 0006_TAP_SBP_Workbook.xlsx | XLSX spreadsheet | |
| Attachment 0010_LMP_Portal_User_Access_Procedures.pdf | ||
| Attachment 0002_TAP_EXAMPLE_PROGRAMS.XLSX | XLSX spreadsheet | |
| Attachment 0005_Wage_Determination_TAP.pdf | ||
| Attachment 0007_TAP_SBP_WorkbookInstructions.pdf |
Show all 19
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
Contractor Coversheet
Direction to Contractor:
Replace this Worksheet with Your Contractor Formatted Coversheet
USG Attachment Coversheet
| UNCLASSIFIED // FOUO | |
| File Name | Attachment_0009_Resource_Distribution_Table.xlsx |
| Reference Attachment | Attachment 0009 |
| Contract Number | TBD |
| Last Updated MOD | W56HZV-19-R-0043 |
All data in this workbook is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet"
DISTRIBUTION STATEMENT E: Distribution authorized to the Department of Defense Components only; (Administrative or Operational use; Export controlled; Proprietary Information) (Date of Determination: 28 January 2019). Other requests for this document shall be referred to the attention of TACOM, US Army TACOM, ATTN: AMSTA-LCG-AA, 6501 East Eleven Mile Road, Detroit Arsenal, MI 48397-5000.
WARNING: This document contains technical data whose export is restricted by the Arms Export Control Act (Title 22 , U.S.C., Sec 2751 , et seq.) or the Export Administration Act of 1979, as amended, (Title 50, U.S.C., App. 2401 et seq .). Violations of these export laws are subject to severe criminal penalties. Disseminate In accordance with revisions of DoD Directive 5230.25.
DESTRUCTION NOTICE: Destroy by any method that will prevent disclosure of contents or reconstruction of the document.
FOIA NOTICE: This document contains information that may be exempt from mandatory disclosure under the Freedom of Information Act (FOIA). Exemption 4 applies (AR 25-55, III.200 FOIA Exemptions).
UNCLASSIFIED // FOUO
Attachment 0009 Resource Distribution Table
Formatting
| UNCLASSIFIED // FOUO | |
| All data on this worksheet is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet" |
| Metadata Reference | ||
| File Name | 1.a | Attachment_0009_Resource_Distribution_Table.xlsx |
| Reference Attachment | 2.a | Attachment 0009 |
| Contract Number | 2.b | TBD |
| Last Updated MOD | 2.c | W56HZV-19-R-0043 |
The Contractor shall only enter values in cells that are colored light yellow (as shown here):
Cells formatted in this color require Offeror input.
UNCLASSIFIED // FOUO
Change Log
UNCLASSIFIED // FOUO
This worksheet documents changes to this attachment between contract modifications (except changes to the 'Change Log' itself, which are self-evident).
Change # Date MOD Number Range Changed Change Description
UNCLASSIFIED // FOUO
Revision Log
| UNCLASSIFIED//FOUO | ||
| All data on this worksheet is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet" | ||
| Metadata Reference | ||
| File Name | 1.a | Attachment_0009_Resource_Distribution_Table.xlsx |
| Reference Attachment | 2.a | Attachment 0009 |
| Contract Number | 2.b | TBD |
| Last Updated MOD | 2.c | W56HZV-19-R-0043 |
| Revision # | Date | Change Description |
| (1…n) | (YYYY-MM-DD) | (Description of changes) |
| (add additional rows as necessary) |
| UNCLASSIFIED//FOUO |
RDT Instructions
| UNCLASSIFIED//FOUO | |||
| All data on this worksheet is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet" | |||
| Metadata Reference | |||
| File Name | 1.a | Attachment_0009_Resource_Distribution_Table.xlsx | |
| Reference Attachment | 2.a | Attachment 0009 | |
| Contract Number | 2.b | TBD | |
| Last Updated MOD | 2.c | W56HZV-19-R-0043 |
| Instructions | 1 | The contractor shall utilize the worksheets titled "Metadata" and "RDT Data" within this attachment as a template to provide the Resource Distribution Table deliverable. | ||
| 2 | Other than cells marked, "(optional)" the contractor shall enter data in all yellow highlighted cells as indicated on each worksheet and in accordance with these instructions. | |||
| 3 | Fill in the required data on the worksheet titled "Metadata" which provides data about the contract, the CDRL deliverable, who prepared the CDRL deliverable, and when the CDRL deliverable was prepared. | |||
| 4 | Fill in the required data on the worksheet titled "RDT Data" as instructed below: | |||
| a) | The total of the "Price" row (5.c) shall equal the contractor's total contract price when all options are exercised. | |||
| b) | Total contract price (row 5.c) shall be broken down into: | |||
| i. | Costs plus profit/fee incurred to preform work internally by the prime contractor, reported in "Prime Contractor" column. | |||
| ii. | Costs incurred to pay subcontractors to provide hardware, software, or other services, reported in columns "All Other Subcontractors" thru "Subcontractor n". | |||
| iii. | Subcontractor costs shall be provided for each subcontractor (row 5.c, columns "Subcontractor 1" thru "Subcontractor n") if the total anticipated price paid to the subcontractor is estimated to exceed $20M during the course of the contract (assuming all options are exercised). Insert and label additional columns between "Subcontractor 1" and "Subcontractor n" as required to provide data for each subcontractor. | |||
| iv. | Costs associated with all subcontractors not anticipated to exceed $20M may be combined and reported in the row labeled 5.c, column "All Other Subcontractors". | |||
| c) | The following information is required, by subcontractor, if the total anticipated price paid to the subcontractor is estimated to exceed $20M during the course of the contract (assuming all options are exercised). | |||
| i. | In the row labeled 5.a, enter the company name of the subcontractor who will be providing the part, software, or service. If the subcontractor is not yet known, enter "TBD". | |||
| ii. | In the row labeled 5.b, enter the city and state (and country if not the United States) the subcontract is located in. If the subcontractor has multiple locations, enter the location the part or software is produced or the service is being completed. If the subcontractor is not yet known, enter "TBD". | |||
| iii. | (Optional) In row labeled 5.d, provide what percentage of the parts, software, or services being procured from the subcontract qualifies as a commercially available item, according to the contractor's assessment (note: only the government's Procuring Contractor Officer makes all final commerciality assessments). The percentage shall be calculated as a percent of total price (the row labeled 5.c) (i.e., price of commercial items divided by price of all items) not as a function of quantity. |
For more info on commerciality, see "https://www.acq.osd.mil/dpap/cpic/cp/docs/Guidebook_Part_A_Commercial_Item_Determination_20180129.pdf"
| iv. | (Optional) In row labeled 5.e, provide what percentage of the parts, software, or services being procured from the subcontract qualifies as a competitively sourced item. An item is considered competitively sourced if the prime contractor has received two or more quotes from independent subcontracts in order to provide the item. The percentage shall be calculated as a percent of total price (the row labeled 5.c) (i.e., price of competitively sourced items divided by price of all items) not as a function of quantity. |
| v. | USG USE ONLY: In row 5.f, enter the OSD(CAPE) Waiver Number associated with the subcontractor and commercial product in question if a waiver has been previously issued by OSD(CAPE). |
| UNCLASSIFIED//FOUO |
Metadata
| UNCLASSIFIED//FOUO | |
| All data on this worksheet is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet" |
| 1. Deliverable Metadata | 1.a | File Name | Attachment_0009_Resource_Distribution_Table.xlsx |
| 1.b | Worksheet Title | Metadata | |
| 1.c | Data Type | RDT | |
| 1.d | Report As of Date | ||
| 1.e | Report Submission Date | ||
| 1.f | Submission Number | ||
| 1.g | Submission Remarks | ||
| 1.h | Proprietary Markings and/or Disclosures | ||
| 1.i | Distribution Statement | E | |
| 1.j | Contains Proprietary Data | Yes | |
| 1.k | Security Classification | Unclassified | |
| 1.l | Data Version | 2019_8 | |
| 2. Contract & Program Metadata | 2.a | Reference Attachment | Attachment 0009 |
| 2.b | Contract Number | TBD | |
| 2.c | Last Updated MOD | W56HZV-19-R-0043 | |
| 2.d | Solicitation Number | W56HZV-19-R-0043 | |
| 2.e | Reference SOW | ||
| 2.f | Reference CDRL | ||
| 2.g | Reference DID | DI-FNCL-81565C | |
| 2.h | Approved CSDR Plan Number | ||
| 2.i | Program Name | TAP | |
| 2.j | Program Phase | O&S | |
| 2.k | Prime Mission Product | ||
| 3. Preparation Metadata | 3.a | Reporting Organization Type | |
| 3.b | Organization Name | ||
| 3.c | Organization Address Line 1 | ||
| 3.d | Organization Address Line 2 | ||
| 3.e | Organization Address City | ||
| 3.f | Organization Address State | ||
| 3.g | Organization Address Zip | ||
| 3.h | Division Name | ||
| 3.i | Division Address Line 1 | ||
| 3.j | Division Address Line 2 | ||
| 3.k | Division Address City | ||
| 3.l | Division Address State | ||
| 3.m | Division Address Zip | ||
| 3.n | Principal Preparer Name | ||
| 3.o | Principal Preparer Phone | ||
| 3.p | Principal Preparer Email | ||
| 4. Additional Fields | 4.a | (Custom Field 01 (optional)) | |
| 4.b | (Custom Field 02 (optional)) | ||
| 4.c | (Custom Field 03 (optional)) | ||
| 4.d | (Custom Field 04 (optional)) | ||
| 4.e | (Custom Field 05 (optional)) | ||
| 4.f | (Custom Field 06 (optional)) | ||
| 4.g | (Custom Field 07 (optional)) | ||
| 4.h | (Custom Field 08 (optional)) | ||
| 4.i | (Custom Field 09 (optional)) | ||
| 4.j | (Custom Field 10 (optional)) | ||
| UNCLASSIFIED//FOUO |
RDT Data
| UNCLASSIFIED//FOUO | |
| All data on this worksheet is subject to the contractor's disclosure statement(s) found on the "Contractor Coversheet" |
| Worksheet Metadata | 1.a | File Name | Attachment_0009_Resource_Distribution_Table.xlsx | ||||||||
| 2.a | Reference Attachment | Attachment 0009 | |||||||||
| 2.b | Contract Number | TBD | |||||||||
| 2.c | Last Updated MOD | W56HZV-19-R-0043 | |||||||||
| --- NOTIONAL EXAMPLE DATA --- | |||||||||||
| 5. RDT Data | Subcontractor 1 | Subcontractor 2 | Prime Contractor | All Other Subcontractors | Subcontractor 1 | Subcontractor 2 | … | Subcontractor n | |||
| 5.a | Subcontractor Name | Vandelay Industries | Kruger Industrial Smoothing | N/A | Various | ||||||
| 5.b | Subcontractor Location | New York, NY | New York, NY | N/A | Various | ||||||
| 5.c | Price | $ 21,000,000.00 | $ 25,000,000.00 | ||||||||
| 5.d | Percent Commercially Available (optional) | 50.0% | 45.0% | N/A | |||||||
| 5.e | Percent Competitively Sourced (optional) | 90.0% | 40.0% | N/A | |||||||
| 5.f | OSD(CAPE) Subcontractor Waiver Number | N/A | N/A | ||||||||
| 5.g | WBS ELEMENT CODE | WBS REPORTING ELEMENTS | |||||||||
| 1.0 | Team Armor Partnership (TAP) | - | - | ||||||||
| 1.1 | Unit-Level Manpower (System Level Cost Only) | - | - | ||||||||
| 1.1.1 | Operations Manpower | - | - | ||||||||
| 1.1.2 | Unit-Level Maintenance Manpower | - | - | ||||||||
| 1.1.3 | Other Unit-Level Manpower (Specify In Remarks) | - | - | ||||||||
| 1.2 | Unit Operations (System Level Cost Only) | - | - | ||||||||
| 1.2.1 | Operating Material | - | - | ||||||||
| 1.2.2 | Support Services (Including Non-Maintenance FSRs) | - | - | ||||||||
| 1.2.3 | Temporary Duty | - | - | ||||||||
| 1.3 | Maintenance | - | - | ||||||||
| 1.3.1 | Consumables and Repair Parts | - | - | ||||||||
| 1.3.1.1 | M1A1/M1A2 Abrams Tank Unique Consumables and Repair Parts | X | - | ||||||||
| 1.3.1.2 | M2A3/M3A3 Bradley Fighting Vehicles (BFV) Unique Equipment | - | - | ||||||||
| 1.3.1.3 | M104 Wolverine Heavy Assault Bridge (Wolverine) Unique Equipment | X | - | ||||||||
| 1.3.1.4 | Common/Other Consumables and Repair Parts | - | - | ||||||||
| 1.3.2 | Depot Level Reparables (DLRs) / Repair of Reparables (RORs) | - | - | ||||||||
| 1.3.2.1 | M1A1/M1A2 Abrams Tank Unique DLRs | - | - | ||||||||
| 1.3.2.2 | M2A3/M3A3 Bradley Fighting Vehicles (BFV) DLRs | - | - | ||||||||
| 1.3.2.3 | M104 Wolverine Heavy Assault Bridge (Wolverine) DLRs | - | X | ||||||||
| 1.3.2.4 | Common/Other DLRs | - | - | ||||||||
| 1.3.3 | Intermediate Maintenance | - | - | ||||||||
| 1.3.4 | Depot Maintenance | - | - | ||||||||
| 1.3.5 | Other Maintenance | - | - | ||||||||
| 1.3.6 | Packing, Handling, Shipping and Transportation (PHS&T) | - | - | ||||||||
| 1.4 | Sustaining Support (System Level Cost Only) | - | - | ||||||||
| 1.4.1 | System Specific Training | - | - | ||||||||
| 1.4.2 | Support Equipment Replacement and Repair | - | - | ||||||||
| 1.4.3 | Sustaining/Systems Engineering | - | - | ||||||||
| 1.4.3.1 | Reliability And Maintainability Engineering | - | - | ||||||||
| 1.4.3.2 | Logistics Engineering (LSA Updates, Logistics Analysis) | - | - | ||||||||
| 1.4.3.3 | Supply Analysis Efforts | - | - | ||||||||
| 1.4.3.4 | Safety/Human Systems Integration Engineering | - | X | ||||||||
| 1.4.3.5 | Affordability Engineering | - | - | ||||||||
| 1.4.3.6 | Obsolescence Engineering | - | - | ||||||||
| 1.4.3.7 | Availability Management | - | - | ||||||||
| 1.4.3.8 | Product Engineering Support | - | - | ||||||||
| 1.4.3.9 | Certification and Accreditation | - | - | ||||||||
| 1.4.3.10 | Configuration Management | - | - | ||||||||
| 1.4.3.11 | System Performance Analysis | - | - | ||||||||
| 1.4.3.12 | Supply | - | - | ||||||||
| 1.4.3.13 | Data Analysis | - | - | ||||||||
| 1.4.3.14 | Physical Security | - | - | ||||||||
| 1.4.4 | Program Management | - | - | ||||||||
| 1.4.4.1 | Contractor Logistics Support (CLS) Management | X | - | ||||||||
| 1.4.4.2 | CLS Supply Management | - | - | ||||||||
| 1.4.4.3 | Financial/Schedule Planning and Reporting | - | - | ||||||||
| 1.4.4.4 | Transition to Lead Service | - | - | ||||||||
| 1.4.4.5 | Quality Assurance (Program Level) | - | - | ||||||||
| 1.4.4.6 | Administrative Security | - | - | ||||||||
| 1.4.4.7 | Transition to Performance Based Logistics (PBL) | - | - | ||||||||
| 1.4.4.8 | Risk Mitigation | - | - | ||||||||
| 1.4.4.9 | CSDR Reporting | - | - | ||||||||
| 1.4.5 | Information Systems | - | - | ||||||||
| 1.4.6 | Data and Technical Publications | - | - | ||||||||
| 1.4.7 | Simulator/Training Device Operations and Repair | - | - | ||||||||
| 1.4.8 | Other Sustaining Support (Specify in Remarks) | - | - | ||||||||
| 1.5 | Continuing System Improvements | - | - | ||||||||
| 1.5.1 | Hardware Modifications | - | - | ||||||||
| 1.5.2 | Software Support | - | - | ||||||||
| 1.6 | Installation and Personnel Support (System Level Only) | - | - |
UNCLASSIFIED//FOUO
image1.png
File details come from the government source that posted it. Updated .