ATTACHMENT - Product Detail.xlsx
XLSX spreadsheet 107 KB Posted
- Attached to
- 6515--Orthotic Softgoods and Prosthetic Supplies
- Solicitation number
- 36S79725R0002
About this file
The file is an Excel attachment (Product Detail.xlsx) providing detailed instructions and a template for vendors to submit product information for a Department of Veterans Affairs (VA) contract for Orthotic Softgoods and Prosthetic Supplies (Solicitation Number 36S79725R0002). The comprehensive template requires vendors to provide extensive product details across 21 columns, including vendor name, part numbers, accessory category, unit of issue, quantity, pricing, commercial name, manufacturer, contract number, HCPC code, and dimensional specifications for boxes, cases, and pallets.
The template is specifically designed for the VA's Veterans Health Administration, Veterans Integrated Service Network 19, and includes three primary tabs: Current List, Deleted Items, and Added Items. Vendors must strictly adhere to the formatting and instructions, with specific guidance on data entry, such as using standardized abbreviations, providing precise pricing without dollar signs, and indicating product status (new, obsolete, or updated). The product groups include Accessories, Batteries, Assistive Devices, Assistive Listening Devices, Orthotic Softgoods, Prosthetic Socks, and CPAP/BI PAP items, with a focus on enabling accurate inventory management and integration into the VA's ordering system (ROES).
View the file
Other files
Show all 32
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
Instructions INSTRUCTIONS TAB: FOLLOW ALL DIRECTIONS, DO NOT MOVE, RENAME OR ADD TABS & COLUMNS
| Colum Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 14 | 16 | 17 | 18 | 19 | 20 | 21 | ORDERING QUANTIES AND ORDERING DIMENSIONS | |||||
| Data Element | 1 - Vendor | 2 – DLC Name | 3 - Part Number | 4 - Old Part Number | 5 - Accessory Category | 6 - Unit of Issue | 7 - Quantity | 8 - Unit Price | 9 - Action | 10 - Blank | 11 – Contract Price | 12 – Commercial Name | 13 - Blank | 14 - Stock Status | 15 - Product Group | 16 - Make/Manufacturer | 17 - Contract Number | 18 - HCPC CODE | 19 - BOC | 20 - FSC | 21 - Minimum Case Qty | BOX/PG DIMENSIONS | BOX/PG QUANTITES | CASE DIMENSIONS | CASE QUANTITIES | PALLET DIMENSIONS | PALLET CASE QUANTITIES |
| Size | 1-36 characters | 1-30 characters | 1-25 characters | 0-25 characters | 1-30 characters | 0 or 2 characters | 0-1 characters | 0 – 60 characters | |||||||||||||||||||
| Description of Data Element | This is the name of the vendor | Shall be limited to 30 characters and adhere to DLC Naming SOP’s guidance | This is the item’s current part number | This is the item’s previous part number if the part number has changed | Primary category item falls under (Hub, Mask, Tube, Adapater, etc.). If a category is not easily identified, vendor shall use a logical, industry-standard term or abbreviation that is intuitive and as close to the commercially published category as possible. | This is the unit of issue for the item. EA (Each), PG (Package), PR (Pair), KT (Kit). | This is the quantity of items included in each unit. | This is the contract price. Enter numbers and decimal only, no dollar sign ($) | This shall be utilized for updating changes or modifying actions. This block should be left blank if there are no changes or modifications. The following codes shall be utilized. 1 shall be used for items that are obsolete (no longer available) with no replacement that should be deleted from contract. 2 shall be used for items that are being deleted and updated and shall utilize the “Old Part Number” column as well. Leave the field blank for all other items. 3 shall be utilized for new items being added to the contract. | This is the price per item given to DLC. Entries shall contain only number and decimal only, no dollar signs ($) do not round numbers | Commercial name given by Vendor, 60 character limit includes any spaces | Describes if this items will be stocked immediately or not. Demand dictates which status the product will be in. Determined internally by DLC/SDC. | Commodity Group assigned: for this product | Provide the make/manufacturer of the product. | Provide the contract number | Provide the HCPC Code associated with that product. | Budget Object code = 2696 (for all items) | Federal Supply Code = 6515 (for all items) | Minimum quantity of individual items/packages in each case. This will also be the order multiple in most situationas as well however demand will dictate the ordering quantities ultimately. | Provide the individual package dimensions. If these items are going to be stocked individually on the shelves these dimensions are useful in determining warehouse space allocation. Use Length X Width X Height formatting. | Qty per box should match column 7 - Quantity per package. | Provide the dimensions of the cases the product is shipped in. If these items are going to be stocked by case on the shelves these dimensions are useful in determining warehosue space allocation. Use Length X Width X Height formatting. | Qty of boxes/pg per case that items are shipped in. Should match Column -21 Minimum Case Qty. | Provide the dimensions of the pallets used. Mainly used for higher demanded/volume items. Use Length X Width X Height formatting. | Qty of cases per pallet that items are shipped in. | ||
| Required/Optional | Required | Required | Required | Optional | Required | Required | Required | Required | Optional | Required | Required | Not Required by Vendor | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | ||
| Notes | Shall be what is indicated on signed contract | Vendor discretion as long as it adheres to DLC Naming Guidance | Vendors updated part number | Vendors pervious contract part number | Vendor discretion as long as it adheres to logical industry-standard terms for each category. | Use DLC abbreviations listed above not vendors. If there is a question contact DLC | IF sold as EA unit quantity will be 1. If sold in a multiple greater than 1 in a single unit, indicate number of units in package | Price charged by vendor under contract | Utilized if changes or modifications are indicated. Once change is listed subsequent listings should be updated and items either removed from listing or updated as indicated. | Price per item given to DLC | Vendor discretion as long as it adheres to DLC Naming Guidance | Vendor will not fill this out, this information will be filled out by DLC/SDC for programming purposes. Enter "yes" if stocked, "no" if buy on demand. | To identify which product group the item will be assigned. Choose from: Accessories, Batteries, Assistive Devices, Assitive Listening Devices, Orthotic Softgoods, Prosthetic Socks, CPAP/BI PAP | This information will be used to display all products associated with the same manufacturer under one drop down menu in ROES. | Each item needs the contract number filled out in this column for programming purposes. | Vendor should provide from most current HCPC. | For all items enter 2696 | For all items enter 6515 | Vendor will work with manufacturer to provide these numbers. | Use these dimensions in ordering quantites based on allocated spacing. | Can be simple as 1 EA per package or in the case of pairs can be 2 pairs per box. | Use these dimensions in ordering quantites based on allocated spacing. | Will help to know this quantitiy to for proper receiving and inventory purposes if stocked by case. Ordering in this multiple helps shipping costs and accuracy of quantities when ordered. | Use these dimensions in ordering quantites based on allocated spacing. | Mostly for higher volume items. Good information to have if demand increases after award. |
Additional Information All fields will remain in the exact place that they are listed here, if they are placed incorrectly attachment will be returned to vendor to be redone. This allows the DLC to add items into ROES, if there is a deviation from this format it will prevent DLC from adding items into ROES. The Current List tab will reflect all items that are currently being offered to the VA. The Deleted Items tab will reflect all items that are being deleted with no replacements from previous Attachment G. The Added Items tab will reflect items that are being added to the current list from the previous Attachment G. These will change with each update.
Current List 1 - Vendor 2 – DLC Name 3 - Part Number 4 - Old Part Number 5 - Accessory Category 6 - Unit of Issue 7 - Quantity 8 - Unit Price 9 - Action 10 – Blank 11 – Contract Price 12 – Commercial Name 13 – Blank 14 - Stock Status 15 - Product Group 16 - Make/Manufacturer 17 - Contract Number 18 - HCPC CODE 19 - BOC 20 - FSC 21 - Minimum Case Qty BOX/PG DIMENSIONS BOX/PG QUANTITES CASE DIMENSIONS CASE QUANTITIES PALLET DIMENSIONS PALLET CASE QUANTITIES
Deleted Items
| SEE INSTRUCTIONS TAB FOR DIRECTIONS | ||||||||||||||||||||||||||
| 1 - Vendor | 2 – DLC Name | 3 - Part Number | 4 - Old Part Number | 5 - Accessory Category | 6 - Unit of Issue | 7 - Quantity | 8 - Unit Price | 9 - Action | 10 – Blank | 11 – Contract Price | 12 – Commercial Name | 13 – Blank | 14 - Stock Status | 15 - Product Group | 16 - Make/Manufacturer | 17 - Contract Number | 18 - HCPC CODE | 19 - BOC | 20 - FSC | 21 - Minimum Case Qty | BOX/PG DIMENSIONS | BOX/PG QUANTITES | CASE DIMENSIONS | CASE QUANTITIES | PALLET DIMENSIONS | PALLET CASE QUANTITIES |
Added Items
| SEE INSTRUCTIONS TAB FOR DIRECTIONS | ||||||||||||||||||||||||||
| 1 - Vendor | 2 – DLC Name | 3 - Part Number | 4 - Old Part Number | 5 - Accessory Category | 6 - Unit of Issue | 7 - Quantity | 8 - Unit Price | 9 - Action | 10 – Blank | 11 – Contract Price | 12 – Commercial Name | 13 – Blank | 14 - Stock Status | 15 - Product Group | 16 - Make/Manufacturer | 17 - Contract Number | 18 - HCPC CODE | 19 - BOC | 20 - FSC | 21 - Minimum Case Qty | BOX/PG DIMENSIONS | BOX/PG QUANTITES | CASE DIMENSIONS | CASE QUANTITIES | PALLET DIMENSIONS | PALLET CASE QUANTITIES |
File details come from the government source that posted it. Updated .