Attachment 1 - EPL.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- KPLER Custom bundle of Commercially Available Off-the-Shelf (COTS) intelligence data packages Federal contract opportunity
- Solicitation number
- HC104725R0006
- Issued by
- Defense Information Systems Agency
About this file
This is an Electronic Parts List (EPL) template spreadsheet that includes detailed instructions for completing product listings and serves as both an Independent Government Cost Estimate (IGCE) and Request for Quote (RFQ) template. The document outlines requirements for a 5-year procurement of Kpler brand name data packages, with each year requiring identical quantities: 2 each of Standard Data Packages for Crude Oil, LNG, LPG/Ethane, Fuel Oils and Residuals, and Lightends/Middle Distillates, plus 1 Data Package for Marine Traffic Enterprise.
The template contains specific guidance for contractors regarding IUID tagging, serial number requirements, and shipping documentation requirements. It requires contractors to provide detailed information including contract numbers, POC information, CAGE codes, and unique entity IDs. The solicitation (HC104725R0006) will be awarded on a Lowest Price Technically Acceptable (LPTA) basis, with quotes due by 1700 EST on January 14, 2025. The Defense Information Systems Agency (DISA) requirement specifies Brand Name only items, with delivery required upon award and no partial deliveries accepted.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 4 - Solicitation Document Amd 001.pdf | ||
| Attachment 3 - Solicitation Document.pdf | ||
| Attachment 2 - Justification and Approval.pdf |
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 Instructions for Completing Consolidated Product Listing to be used for IGCE/RFQ/EPL/MI&RR This template should be tailored to fit the individual procurement. Remove all examples and notes from the completed document, and change font color to black as appropriate. Comments and/or suggestions regarding this template should be forwarded to the PS21 Policy Branch Mailbox.
| Mission Partners shall complete the narrative tab to include the basis of the estimate and sign in the narrative tab at completion of the IGCE. This document is not complete until the basis of estimate (narrative) and signature have been added |
| Customers shall work with their respective Property Accountability Office in order to determine in advance which of the requested item(s) require assignment of an Item Unique Identification (IUID) valuation tag in accordance with the guidance contained in DFARS 252.2011-7003. Each item that requires an IUID tag and collection/submission of required information must be clearly identified on the spreadsheet by leaving column M blank. If the contractor will not be required to provide either an IUID tag and/or IUID information, column O should indicate accordingly. |
| Note for DISA requirements only: DISA property accountability manager has determined it to be in the best interest of the Government to upload the required information into the Defense Property Accountability System (DPAS) in order to generate and affix IUID tags on items after delivery. Contractors will NOT be required to generate or provide IUID tags. However, all information outlined on the Electronic Parts List (EPL) MUST be provided with each shipment in order to allow for generation of the physical IUID tag. |
| When submitting requirements for a specific brand name item (accompanied by the appropriate Justification for Other than Full and Open Competition), those items should be marked as “BN” in column B. Items which are to be competed on an “or equal” basis should be marked accordingly so contractors understand how to respond. Column B should be completed for each Contract Line Item (CLIN). |
| If purchasing a complete configurable system, a single CLIN may be used to identify all components associated with the top level assembly. Orders will be placed for a single system based upon the configuration using the Unit of Measure (UoM) "each." Multiple systems can be ordered on a single line item on the contract as long as all will have the exact same configuration. The configuration Bill of Materials (BOM) will be incorporated into the resulting contract as an attached document. |
| If an IUID tag is required for a component or subassembly of a configurable product, the per unit price of the item must be collected and reported. Whenever the need for an IUID tag is indicated, the offeror cannot decline to provide a per unit price by listing the item as not separately priced (NSP). |
| Within a CLIN for single system, sub elements/subassemblies may also require serial numbers and/or IUID tags. When required, the customer shall leave the appropriate columns blank to indicate to the contractors that information must be provided. If information is not required, columns L through N should indicate accordingly. |
| If a serial number is not required (or not provided in accordance with industry standards), column L should be indicated accordingly. |
| Small dollar items such as spares or peripheral equipment for a tech refresh (estimated per unit price of $5K or less) may be grouped together into one BOM for ordering purposes. |
| The completed spreadsheet shall be submitted to DITCO along with all required documentation for review. One copy of the document will be retained in the contract file marked “IGCE”. Another copy will be created with the per unit prices removed and labeled as “RFQ or Proposal Template”. This copy will be included in the RFQ/Proposal and shall be the basis for the offeror’s RFQ/Proposal. At the time the spreadsheet is forwarded in an RFQ/Proposal, columns O through AB will be hidden. Instructions to offerors will explain use of these columns after award. |
| During the evaluation process, the Contract Specialist and Contracting Officer will review proposed CLIN structure with the customer to determine if additional changes are necessary before contract award. |
| Columns Q, R and S will be completed by DITCO and the remaining columns unhidden for distribution with the award documents. Contractors will be instructed to submit a completed document with each shipment in order to meet the requirements for submission of an EPL. When more than one item is shipped per CLIN, all serial numbers and IUID tag information shall be inserted in the appropriate columns separated by semi-colons. |
| In order to assist in identifying a specific shipment to a specific order, contractors are required to provide the name of the carrier and the tracking number for each shipment on the completed EPL. When items are drop shipped from the Original Equipment Manufacturer (OEM), the contractor shall obtain the necessary information from the OEM and submit the completed EPL so that it is received on/before shipment arrives at the destination outlined in the contract. |
| In addition to submission of DD250, Material Inspection and Receiving Report, contractors shall attach a copy of the consolidated EPL with each shipment. To meet the information requirements for this document, columns T through AB must also be completed. IAW DFARS 252.211-7003, completed DD250 and the attachment must be included with invoices submitted in Wide Area WorkFlow (WAWF). |
| For further guidance, please reference the IGCE Desk book located at https://www.ditco.disa.mil/hq/Deskbooks. |
(CUI) JEDI Ciena MBOM
| CONTRACTOR REQUIRED INFORMATION | ||||||||||||||||||
| Contractor Contract # (SEWP / GSA): | ||||||||||||||||||
| CONTRACTOR POC Name: | ||||||||||||||||||
| POC Email: | ||||||||||||||||||
| POC Phone #: | ||||||||||||||||||
| CAGE Code | ||||||||||||||||||
| Unique Entity ID # | ||||||||||||||||||
| Columns in green form the basis for Contractor's Quote (RFQ) | ||||||||||||||||||
| When completed, the columns in goldenrod fulfill the requirements to submit an Electronic Products List (EPL) IAW DITCO Additional Text H2 (Completed by Contractor) | ||||||||||||||||||
| ITEM # (Proposed CLIN) | Brand Name (BN) or Equal? | Manufacturer Name | Manufacturer Part Number | Description | QTY | UNIT OF ISSUE | UNIT PRICE | EXTENDED AMOUNT | Promised Delivery (ARO) | Covered by OEM Warranty (type and duration) | Software License Included (Duration) | SW Serial Number/Key Code | HW Serial Number/Key Code | Contract Number | Delivery Order Number (if applicable) | Funding Document Number | Contract Line Item No. (CLIN) SubCLIN (SLIN) | Customer Organization |
| 0001 | BN | KPLER | N/A | Standard Data Package - Crude Oil | 2 | EA | ||||||||||||
| 0002 | BN | KPLER | N/A | Standard Data Package - LNG | 2 | EA | ||||||||||||
| 0003 | BN | KPLER | N/A | Standard Data Package - LPG/Ethane | 2 | EA | ||||||||||||
| 0004 | BN | KPLER | N/A | Standard Data Package - Fuel Oils and Residuals | 2 | EA | ||||||||||||
| 0005 | BN | KPLER | N/A | Standard Data Package - Lightends and middle distillates | 2 | EA | ||||||||||||
| 0006 | BN | KPLER | N/A | Data Package - Marine Traffic Enterprise | 1 | EA | ||||||||||||
| 1001 | BN | KPLER | N/A | Standard Data Package - Crude Oil | 2 | EA | ||||||||||||
| 1002 | BN | KPLER | N/A | Standard Data Package - LNG | 2 | EA | ||||||||||||
| 1003 | BN | KPLER | N/A | Standard Data Package - LPG/Ethane | 2 | EA | ||||||||||||
| 1004 | BN | KPLER | N/A | Standard Data Package - Fuel Oils and Residuals | 2 | EA | ||||||||||||
| 1005 | BN | KPLER | N/A | Standard Data Package - Lightends and middle distillates | 2 | EA | ||||||||||||
| 1006 | BN | KPLER | N/A | Data Package - Marine Traffic Enterprise | 1 | EA | ||||||||||||
| 2001 | BN | KPLER | N/A | Standard Data Package - Crude Oil | 2 | EA | ||||||||||||
| 2002 | BN | KPLER | N/A | Standard Data Package - LNG | 2 | EA | ||||||||||||
| 2003 | BN | KPLER | N/A | Standard Data Package - LPG/Ethane | 2 | EA | ||||||||||||
| 2004 | BN | KPLER | N/A | Standard Data Package - Fuel Oils and Residuals | 2 | EA | ||||||||||||
| 2005 | BN | KPLER | N/A | Standard Data Package - Lightends and middle distillates | 2 | EA | ||||||||||||
| 2006 | BN | KPLER | N/A | Data Package - Marine Traffic Enterprise | 1 | EA | ||||||||||||
| 3001 | BN | KPLER | N/A | Standard Data Package - Crude Oil | 2 | EA | ||||||||||||
| 3002 | BN | KPLER | N/A | Standard Data Package - LNG | 2 | EA | ||||||||||||
| 3003 | BN | KPLER | N/A | Standard Data Package - LPG/Ethane | 2 | EA | ||||||||||||
| 3004 | BN | KPLER | N/A | Standard Data Package - Fuel Oils and Residuals | 2 | EA | ||||||||||||
| 3005 | BN | KPLER | N/A | Standard Data Package - Lightends and middle distillates | 2 | EA | ||||||||||||
| 3006 | BN | KPLER | N/A | Data Package - Marine Traffic Enterprise | 1 | EA | ||||||||||||
| 4001 | BN | KPLER | N/A | Standard Data Package - Crude Oil | 2 | EA | ||||||||||||
| 4002 | BN | KPLER | N/A | Standard Data Package - LNG | 2 | EA | ||||||||||||
| 4003 | BN | KPLER | N/A | Standard Data Package - LPG/Ethane | 2 | EA | ||||||||||||
| 4004 | BN | KPLER | N/A | Standard Data Package - Fuel Oils and Residuals | 2 | EA | ||||||||||||
| 4005 | BN | KPLER | N/A | Standard Data Package - Lightends and middle distillates | 2 | EA | ||||||||||||
| 4006 | BN | KPLER | N/A | Data Package - Marine Traffic Enterprise | 1 | EA |
GRAND TOTAL $ - 0
| REQUESTED DELIVERY DATE: | All items to be delivered upon award (Partial deliveries will not be accepted) |
| DELIVER ITEMS TO: |
| Ship to Address: | To be provided upon Award |
| Point of Contact (POC): | To be provided upon Award |
| Office Name/Symbol: | |
| POC Phone #: | |
| POC Email: | |
| Alternate POC: | To be provided upon Award |
| Office Name/Symbol: | |
| Alternate POC Phone #: | |
| Alternate POC Email: | |
| Property Custodian: | To be provided upon Award |
| Property Custodian Phone #: | |
| Property Custodian Email: |
File details come from the government source that posted it. Updated .