Attachment 005 - As-Built Configuration Template.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Mobile Tactical Cannon - Tracked (MTC-T) and Resupply Vehicle – Tracked (RSV-T) Capability Solutions
- Solicitation number
- MOSAIC-27-01
- Issued by
-
Department of the Army
About this file
This file is an As-Built Configuration Template in Excel format that provides a data schema for documenting the hierarchical assembly structure and component details of manufactured products. The template establishes 23 data columns with specific field requirements for capturing product configuration information, including program identification, part numbers, component descriptions, serial and lot number tracking, manufacturing dates, manufacturer CAGE codes, acceptance dates, and higher-level assembly relationships. The template accommodates multiple message fields to record contract information, waivers, deviations, and special characteristics applicable to individual items.
The template is designed for use in the Mobile Tactical Cannon-Tracked (MTC-T) and Resupply Vehicle-Tracked (RSV-T) solicitation (MOSAIC-27-01), where the Army Contracting Command - Detroit Arsenal is seeking a mature, tracked self-propelled 155mm howitzer system from existing production lines. Contractors selected to submit proposals must use this configuration template to document the as-built status of delivered systems, capturing the complete bill of materials with traceability from end items through all reportable subassemblies and components. The template enforces data standardization through defined field lengths and content types, with mandatory fields for life-limited items including manufacture dates referenced from DD1650 ammunition data cards and acceptance dates from certificates of conformance.
View the file
Other files
Show all 21
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
Data Field Legend
| DISTRIBUTION STATEMENT A: Approved for Public Release; distribution is unlimited. |
| The information below will provide guidance on the data required to populate Sheet 2 |
| Column Number | Column Name | Field Length | Field Content Description |
| 1 | Program Id | Char(16) | The abbreviated identifier for the name of the product. |
| 2 | Program Name | Char(42) | The name of the product. |
| 3 | Indenture Level | Char(2) | The numbered indenture of where the component resides within the reportable hierarchical assembly structure (Drawing tree or CARL). |
| 4 | Part Number | Char(26) | The part number of the item, normally the drawing number (with applicable dash suffix) |
| 5 | Reference Designator | Char(15) | An abbreviated descriptor for the unit/assembly of the item. |
| 6 | Part Description | Char(80) | Nomenclature (description) of the item, normally the drawing title. |
| 7 | Part Number Sequence Number | Num(2) | A unique, sequential number for each item starting at zero for the end item and incrementing by one for each additional reportable item. |
| 8 | Serial/Lot Type | Char(6) | An identifier that determines the content of the "Serial/Lot Number" (column 9) and the "Lot Number" (column 13) columns. Acceptable values: |
| SERIAL (column 9 contains Item Serial Number, column 13 blank) | |||
| SERLOT (column 9 contains Item Serial Number, column 13 contains Manufacturer Lot Number) | |||
| LOT (column 9 contains Manufacturer Lot Number, column 13 blank) |
| 9 | Serial/Lot Number | Char(20) | Serial number or lot number as determined by the content of the Serial/Lot Type (column 8) as marked on the physical item. |
| 10 | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK |
| 11 | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK |
| 12 | Drawing Revision | Char(4) | Drawing revision of part number used to build the item. |
| 13 | Lot Number | Char(20) | Manufacturer Lot number as marked on the physical item (formatted per MIL-STD-1168B). |
| 14 | Manufacture Date | Date-time | (MM-DD-YYYY) - Date item was manufactured. Mandatory for life-limited items with date from Block 12 of applicable DD1650 (Ammunition Data Card) |
| 15 | Manufacturer Cage Code | Char(5) | CAGE Code of original item manufacturer. |
| 16 | Acceptance Date | Date-time | (MM-DD-YYYY HH:MM) - Date the item was certified as complete. (i.e. Signature date of the certificate of conformance.) |
| 17 | NHA Part Number | Char(26) | Next Higher Assembly part number of the item. |
| 18 | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK | INTENTIONALLY LEFT BLANK |
| 19 | End Item Part Number | Char(26) | Part number of the end item (must be exactly the same as the part number on the first row of the file). |
| 20 | End Item Internal Serial Number | Char(20) | Serial number of the end item (must be exactly the same as the serial number on the first row of the file). |
| 21 | Message Description | Char (20) | Category/type (label) for each message. Describes the category of the message group when column 23 is the number “1”. Each row after the first contains a message type. May be blank for an item if there are no messages. |
| 22 | Message | Char (80) | Contains information describing the item (e.g. contract information, Waivers/deviations applied, amplification details, or special characteristics of the tem). May be blank or more than one per item. |
| 23 | Message Sequence Number | Char (2) | Number (starting at one) uniquely identifies each message for an item. May be blank for an item if there are no messages. |
DRAFT
Sheet2 Program Id Program Name Indenture Level Part Number Reference Designator Part Description Part Number Sequence Serial/Lot Type Serial/Lot Number INTENTIONALLY LEFT BLANK INTENTIONALLY LEFT BLANK Drawing Revision Lot Number Manufacture Date Manufacturer CAGE Code Acceptance Date NHA Part Number INTENTIONALLY LEFT BLANK End Item Part Number End Item Internal Serial Number
File details come from the government source that posted it. Updated .