Attachment 0003 Resource Distribution Table - 102025 revision.xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- DRAFT Request for Proposal Project Management Mounted Armored Vehicle Logistic Fielding Support Services
- Solicitation number
- W912CH-25-R-0182
- Issued by
-
Department of the Army
About this file
This is a Resource Distribution Table (RDT) template and instruction document for the PM Mounted Armored Vehicles (MAV) Logistic Fielding Support Services contract (Solicitation W912CH-25-R-0182). The template serves as a CDRL (Contract Data Requirements List) deliverable that contractors must complete to report resource distribution across prime contractor and subcontractor efforts.
The RDT requires contractors to provide detailed metadata about the contract, program, and preparing organization, then populate a data worksheet breaking down total contract price by prime contractor internal costs and individual subcontractor costs (for subcontractors exceeding $20 million anticipated value). For each major subcontractor, contractors must identify the subcontractor name and location, allocate costs across a comprehensive Work Breakdown Structure (WBS) that covers logistics fielding support services including unit-level maintenance, operations, training, maintenance consumables, depot-level reparables, intermediate and depot maintenance, sustaining support, and continuing system improvements. Contractors must also mark which WBS elements each subcontractor supports and optionally provide percentages for commercially available and competitively sourced items. The document includes detailed instructions on data entry requirements, worksheet structure, and optional fields for commerciality assessments and competitive sourcing documentation, with all contractor-entered data restricted to yellow-highlighted cells unless otherwise specified.
View the file
Other files
Show all 15
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
RDT Instructions
CUI
| Metadata Reference | |||
| File Name | 1.a | ERROR:#VALUE! | |
| Reference Attachment | 2.a | Attachment 0003 | |
| Contract Number | 2.b | 0 | |
| Last Updated MOD | 2.c | 0 |
| 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 (see the NOTONAL EXAMPLE in columns E and F on "RDT Data" worksheet for two example subcontractor columns): | |||
| 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. |
A subcontract is any agreement, purchase order, or instrument other than a prime contract calling for work or for the material required for the performance of one or more prime contracts. It usually covers procurement of major components or subsystems that require the subcontractor to do extensive design, development, engineering, and testing to meet a prime contractor’s procurement specifications. (Via DoD Manual 5000.04 - Cost and Software Data Reporting (CSDR) Manual)
| 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. | For each WBS identified in section 5.g and for each of the "Subcontractor 1" thru "Subcontractor n" columns, enter an "X" in the cell at the subcontractor-WBS intersection if the subcontractor identified in the column is completing work associated with the WBS identified in the row. If the subcontractor is not completing work associated with the WBS, enter "-". | |
| iv. | (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/dars/pgi/docs/DoD_Guidebook_PartA_Commercial_Item_Determination_07_10_19.pdf"
| v. | (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. |
| vi. | 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). |
| CUI |
Formatting
CUI
| Metadata Reference | ||
| File Name | 1.a | ERROR:#VALUE! |
| Reference Attachment | 2.a | Attachment 0003 |
| Contract Number | 2.b | 0 |
| Last Updated MOD | 2.c | 0 |
The Contractor shall only enter values in cells that are colored light yellow (as shown here) unless otherwise noted:
Cells formatted in this color require contractor input unless otherwise noted.
CUI
Change Log
CUI
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
CUI
Revision Log
CUI
| Metadata Reference | |||
| File Name | 1.a | ERROR:#VALUE! | |
| Reference Attachment | 2.a | Attachment 0003 | |
| Contract Number | 2.b | 0 | |
| Last Updated MOD | 2.c | 0 |
| Complete one row per submission. | ||||
| Submission Number | Resubmission Number | |||
| Author: If the report is a resubmission, enter the resubmission number, starting with “1” for the first resubmission, “2” for the second resubmission, and so forth. Enter “0” for original submission. | Date | Change Description | ||
| (1…n) | (0…n) | (YYYY-MM-DD) | (Description of changes) |
| (add additional rows as necessary) |
| CUI |
Metadata
CUI
| 1. Deliverable Metadata | 1.a | File Name | ERROR:#VALUE! | |
| 1.b | Worksheet Title | ERROR:#VALUE! | ||
| 1.c | Data Type | RDT | ||
| 1.d | Report As of Date | (YYYY-MM-DD) | ||
| 1.e | Report Submission Date | (YYYY-MM-DD) | ||
| 1.f | Submission Number | (1…n) | ||
| 1.g | Resubmission Number | |||
| Author: If the report is a resubmission, enter the resubmission number, starting with “1” for the first resubmission, “2” for the second resubmission, and so forth. Enter “0” for original submission. | (0…n) | |||
| 1.h | Submission Remarks | |||
| 1.i | Proprietary Markings and/or Disclosures | |||
| 1.j | Distribution Statement | D | ||
| 1.k | Contains Proprietary Data | Yes | ||
| 1.l | Security Classification | Unclassified | ||
| 1.m | Data Version | 2024_2 | ||
| 2. Contract & Program Metadata | 2.a | Reference Attachment | Attachment 0003 | |
| 2.b | Contract Number | |||
| 2.c | Last Updated MOD | |||
| 2.d | Solicitation Number | W912CH-25-R-0182 | ||
| 2.e | Reference SOW | C.4.5 | ||
| 2.f | Reference CDRL | A005 | ||
| 2.g | Reference DID | DI-FNCL-81565C | ||
| 2.h | Approved CSDR Plan Number | TBD | ||
| 2.i | Program Name | PM Mounted Armored Vehicles (MAV) (AMPV, Bradley, M113, M88 FoV) | ||
| 2.j | Program Phase | PROC & O&S | ||
| 2.k | Prime Mission Product | PM MAV Logistics Fielding System Support | ||
| 3. Preparation Metadata | 3.a | Reporting Organization Type |
Author: - Enter "Contractor" if the reporiting entity is the prime contractor.
- Enter "Subcontractor" if the reporting entity is a subcontractor.
| 3.b | Organization Name | |
| 3.c | Organization Address Line 1 | |
| 3.d | Organization Address Line 2 (optional) | |
| 3.e | Organization Address City | |
| 3.f | Organization Address State | |
| 3.g | Organization Address Zip | |
| 3.h | Division Name (optional) | |
| 3.i | Division Address Line 1 (optional) | |
| 3.j | Division Address Line 2 (optional) | |
| 3.k | Division Address City (optional) | |
| 3.l | Division Address State (optional) | |
| 3.m | Division Address Zip (optional) | |
| 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)) | |
| CUI |
RDT Data
CUI
| Worksheet Metadata | 1.a | File Name | ERROR:#VALUE! | ||||||||
| 2.a | Reference Attachment | Attachment 0003 | |||||||||
| 2.b | Contract Number | 0 | |||||||||
| 2.c | Last Updated MOD | 0 | |||||||||
| --- 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 | PM MAV Logistic Fielding Support Services (LFSS) | - | - | ||||||||
| 1.1 | Unit-Level Manpower | - | - | ||||||||
| 1.1.1 | Operations | - | - | ||||||||
| 1.1.2 | Unit-Level Maintenance | X | - | ||||||||
| 1.1.3 | Other Unit-Level (1...n Specify) | - | - | ||||||||
| 1.2 | Unit Operations | - | - | ||||||||
| 1.2.1 | Energy (Fuel, Petroleum, Oil and Electricity) | - | - | ||||||||
| 1.2.1.1 | Fuel | - | - | ||||||||
| 1.2.1.2 | Petroleum, Oil and Lubricants (POL) | - | - | ||||||||
| 1.2.1.3 | Electricity | - | - | ||||||||
| 1.2.2 | Training Munitions and Expendable Stores | - | - | ||||||||
| 1.2.2.1 | Ammunition | - | - | ||||||||
| 1.2.2.2 | Bombs | X | - | ||||||||
| 1.2.2.3 | Rockets | - | - | ||||||||
| 1.2.2.4 | Training Missiles | - | - | ||||||||
| 1.2.2.5 | Sonobuoys | - | - | ||||||||
| 1.2.2.6 | Pyrotechnics | - | - | ||||||||
| 1.2.2.7 | Other Munitions | - | - | ||||||||
| 1.2.3 | Support Services | - | X | ||||||||
| 1.2.3.1 | Non-Maintenance Field Service Reps | - | - | ||||||||
| 1.2.3.2 | Communication Services | - | - | ||||||||
| 1.2.3.3 | Facility/Storage Services | - | - | ||||||||
| 1.2.3.4 | Transportation Services | - | - | ||||||||
| 1.2.3.5 | Other Support Services | - | - | ||||||||
| 1.2.4 | Temporary Duty (TDY) Travel | - | - | ||||||||
| 1.2.5 | Second Destination Transportation | - | - | ||||||||
| 1.3 | Maintenance | - | - | ||||||||
| 1.3.1 | Consumables | - | - | ||||||||
| 1.3.1.1 | Airframe/Hull/Vehicle Consumables and Repair Parts | - | - | ||||||||
| 1.3.1.2 | Propulsion Consumables and Repair Parts | - | - | ||||||||
| 1.3.1.3 | Electronics/Avionics Consumables and Repair Parts | - | - | ||||||||
| 1.3.1.4 | Other Major Subsystem Consumables and Repair Parts 1..n (Specify) | - | - | ||||||||
| 1.3.1.5 | Other Consumables and Repair Parts | - | - | ||||||||
| 1.3.2 | Depot Level Reparables (DLRs) | - | - | ||||||||
| 1.3.2.1 | Airframe/Hull/Vehicle DLRs | - | - | ||||||||
| 1.3.2.2 | Propulsion DLRs | X | - | ||||||||
| 1.3.2.3 | Electronics/Avionics DLRs | - | - | ||||||||
| 1.3.2.4 | Other Major Subsystems DLRs 1..n (Specify) | - | - | ||||||||
| 1.3.2.5 | Other DLRs | - | - | ||||||||
| 1.3.3 | Intermediate Maintenance (External to Unit-Level) | - | - | ||||||||
| 1.3.3.1 | Intermediate Maintenance Consumable Materials and Repair Parts | - | - | ||||||||
| 1.3.3.2 | Intermediate-Level Government Maintenance | - | - | ||||||||
| 1.3.3.3 | Intermediate-Level Contractor Maintenance | - | - | ||||||||
| 1.3.3.4 | Other Intermediate-Level Maintenance | - | - | ||||||||
| 1.3.4 | Depot Maintenance | - | - | ||||||||
| 1.3.4.1 | Scheduled Depot Maintenance | - | - | ||||||||
| 1.3.4.1.1 | Airframe/Hull/Vehicle Scheduled Overhaul | X | - | ||||||||
| 1.3.4.1.2 | Propulsion Scheduled Overhaul | - | - | ||||||||
| 1.3.4.1.3 | Electronics/Avionics Scheduled Overhaul | - | - | ||||||||
| 1.3.4.1.4 | Other Major Subsystems Scheduled Overhaul 1..n (Specify) | - | - | ||||||||
| 1.3.4.1.5 | Other Scheduled Overhaul | - | - | ||||||||
| 1.3.4.2 | Unscheduled Depot Maintenance | - | - | ||||||||
| 1.3.4.2.1 | Airframe/Hull/Vehicle Unscheduled Overhaul | - | X | ||||||||
| 1.3.4.2.2 | Propulsion Unscheduled Overhaul | - | - | ||||||||
| 1.3.4.2.3 | Electronics/Avionics Unscheduled Overhaul | - | - | ||||||||
| 1.3.4.2.4 | Other Major Subsystems Unscheduled Overhaul 1..n (Specify) | - | - | ||||||||
| 1.3.4.2.5 | Other Unscheduled Unscheduled Overhaul | - | - | ||||||||
| 1.4 | Sustaining Support | - | - | ||||||||
| 1.4.1 | System-Specific Training | - | - | ||||||||
| 1.4.1.1 | System-Specific Operator Training | - | - | ||||||||
| 1.4.1.2 | System-Specific Maintenance Training | - | - | ||||||||
| 1.4.2 | Support Equipment Replacement and Repair | - | - | ||||||||
| 1.4.2.1 | Support Equipment Replacement | - | - | ||||||||
| 1.4.2.2 | Support Equipment 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 | - | - | ||||||||
| 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 | - | - | ||||||||
| 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 | Data and Technical Publications | - | - | ||||||||
| 1.4.5.1 | Data Management | - | - | ||||||||
| 1.4.5.2 | Technical Publications | - | - | ||||||||
| 1.4.5.2.1 | Integrated Electronic Technical Manuals (IETMS) | - | - | ||||||||
| 1.4.5.2.2 | Traditional Paper Technical Manuals | - | - | ||||||||
| 1.4.5.3 | Drawings | - | - | ||||||||
| 1.4.5.4 | Software Change Documentation | - | - | ||||||||
| 1.4.6 | Simulator Operations and Repair | - | - | ||||||||
| 1.4.6.1 | Simulator/Training Device Operations | - | - | ||||||||
| 1.4.6.2 | Simulator/Training Device Hardware Repair and Replace | - | - | ||||||||
| 1.4.6.3 | Simulator/Training Device Software Support | - | - | ||||||||
| 1.4.7 | Other Sustaining Support 1...n (Specify) | - | - | ||||||||
| 1.5 | Continuing System Improvements | - | - | ||||||||
| 1.5.1 | Hardware Modifications | - | - | ||||||||
| 1.5.1.1 | Mod Kit Development | - | - | ||||||||
| 1.5.1.2 | Mod Kit Procurement | - | - | ||||||||
| 1.5.1.3 | Mod Kit Initial Spares | - | - | ||||||||
| 1.5.1.4 | Mod Kit Installation | - | - | ||||||||
| 1.5.2 | Software Maintenance | - | - | ||||||||
| 1.5.2.1 | Software Changes | - | - | ||||||||
| 1.5.2.1.1 | Release 1...n (Specify) | - | - | ||||||||
| 1.5.2.1.1.1 | WBS Name 1...n (Specify) | - | - | ||||||||
| 1.5.2.1.1.1.1 | Correction of Deficiencies | - | - | ||||||||
| 1.5.2.1.1.1.2 | Enhancements | - | - | ||||||||
| 1.5.2.2 | Software Program Management | - | - | ||||||||
| 1.5.2.3 | Software Sustaining Engineering | - | - | ||||||||
| 1.5.2.4 | System Facilities | - | - | ||||||||
| 1.5.2.5 | Field Service Engineers | - | - | ||||||||
| 1.5.2.6 | Certification and Accreditation | - | - | ||||||||
| 1.5.2.7 | HelpDesk | - | - | ||||||||
| 1.5.2.8 | Hosting | - | - | ||||||||
| 1.5.2.9 | Software Licenses | - | - |
CUI
File details come from the government source that posted it. Updated .