Copy of Attachment 0015-LORA.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Water Storage Distribution System (Solicitation)
Solicitation number
W56HZV21R0011
Issued by

About this file

This document contains details regarding a federal contract solicitation for water storage and distribution systems. The U.S. Army Contracting Command-Detroit Arsenal intends to procure up to 123 water storage distribution systems to provide large capacity potable water storage and distribution capabilities. The systems will include 87 units with a 100,000 gallon capacity and 36 units with a split 50,000 gallon capacity. There is also an option to procure up to 150 spare 350 gallon per minute fluid distribution pumps. The resulting contracts will be fixed price, indefinite delivery/indefinite quantity agreements with the Army for five years and two optional additional ordering years. This procurement is open only to small businesses. Interested parties should contact the named buyer by phone for additional information.

View the file

Other files

File Type Posted
WSDS QA 91-95.pdf PDF
Attachment 0010 SESAME.xlsx XLSX spreadsheet
W56HZV21R0011-0003.pdf PDF
W56HZV21R0011-0002.pdf PDF
WSDS VENDOR QA (10 June) (questions 36-90) Final.pdf PDF
Attachment 0009 WSDS FDSC Certified 16 Apr 21.pdf PDF
Attach 0009 WSDS FDSC Certified 16 Apr 21.pdf PDF
Attachment_0042_Pricing_Workbookv2 (4 Jun 21).xlsx XLSX spreadsheet
Attachment_0040_Pricing_Workbookv2 (4 Jun 21).xlsx XLSX spreadsheet
Attachment_0040_Pricing_Workbookv2.xlsx XLSX spreadsheet
Attachment_0042_Pricing_Workbookv2.xlsx XLSX spreadsheet
Notice to Offerors.pdf PDF
WSDS Amendment 0001 6-1-21 - signed.pdf PDF
Attachment 0003 ATPD-2425A WSDS.pdf PDF
Attachment_0040_Pricing_Workbookv2.xlsx XLSX spreadsheet
Attachment_0042_Pricing_Workbookv2.xlsx XLSX spreadsheet
WSDS VENDOR QA (as of 25 May 2021).pdf PDF
ATPD-2425A WSDS.pdf PDF
Instructions as of 25 May 2021.docx DOCX document
WSDS VENDOR QA (as of 10 May 2021).pdf PDF
Attachment 0024-TPG 2016-01 Rev 1 Source Data.pdf PDF
Attachment 0033- Department of Defense Guide to Item Unique Identification Quality Assurance.doc DOC document
Instructions.docx DOCX document
Attachment 0018-DE Style Guide 1-26-18.pdf PDF
Attachment 0009- Failure Definition and Scoring Criteria (FDSC).docx DOCX document
Attachment 0022-TABLE A-VII-NMWR Requirements Matrix.docx DOCX document
Attachment 0020-TABLE A-IV - TM Requirements Matrix -23.docx DOCX document
Attachment 0035- MOS Operator and Maintenance Tasks 92W-91J.docx DOCX document
Copy of Attachment 0040 - Pricing Workbook revised 4 20 2021.xlsx XLSX spreadsheet
Attachment 0021-TABLE A-VI - TM Requirements Matrix -23P RPSTL.DOCX DOCX document
Copy of Attachment 0005- HMMR Format.XLSX XLSX spreadsheet
Attachment 0037 PKG1_LPD Coded Data Products Packaging.docx DOCX document
Attachment 0004- Request for Use of Prohibited Materials.doc DOC document
Attachment 0019-TABLE A-II - TM Requirements Matrix -10.docx DOCX document
Attachment 0031-Microscan UID Compliance Results.pdf PDF
Attachment 0008- Product Format Government TDP Requirements.docx DOCX document
Attachment 0030 - Pump Reliability and Mobility PQT Plan WSDS-v16.docx DOCX document
Copy of Attachment 0041 - Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Attachment 0016-Tool Criteria and Approval.docx DOCX document
Attachment 0006- CARC Paint Drawing 12585018.pdf PDF
Attachment 0007 - WSDS Technical Data Package (TDP).zip ZIP file
Attachment 0002-PEO CSCSS OPSEC Program.pdf PDF
Attachment 0038_Technical Review Criteria.docx DOCX document
Attachment 0034- Additional Guidelines for Controlled Unclassified Information.docx DOCX document
Copy of Attachment 0010-SESAME.xlsx XLSX spreadsheet
Attachment 0017- AMPS Procedures for Users and Administrators.pdf PDF
Copy of Attachment 0042 - Updated Pricing Workbook.xlsx XLSX spreadsheet
Attachment 0026-IADS Dataset_TOC File Template.docx DOCX document
Attachment 0029- Provisioning Requirements Worksheet.docx DOCX document
Attachment 0039 - Copyright Release Letter Template.docx DOCX document
Show 40 more

Latest 50 of 61 listed here. See the rest on GovTribe.

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

Table 1

TabsValuesNotes
End Item Information
Number of Systems2607AAO
System Life25CPD
Annual Operating Hours7300Wartime 20 hrs/day 365
Availability Target0.9Pre-populates, but merits discussion
End Item Floats AvailableNo
Echelons
ORG Number of Shops
Supply Data
Initial Bin Cost ($)303.57Pre-populated but may need to be adjusted
Recurring Bin Cost ($)48.7Pre-populated but may need to be adjusted
Cost per Requisition ($)25.89Pre-populated but may need to be adjusted
Initial Catalog Cost ($)1043.14Pre-populated but may need to be adjusted
Recurring Catalog Cost ($)441.48Pre-populated but may need to be adjusted
Procurement Lead Time (days)365This value represents ALT+PLT. PSMIPT agreed to (ALT 12 months). Need AVG PLT
Hold Cost Fraction (%)6Pre-populated but may need to be adjusted
Documentation Cost Per Page ($/page)591.61TM- Looks low based previous experience
Discount Rate (%)2.2Pre-populated but may need to be adjusted
Wholesale Fill Rate (%)90PSMIPT (Recent guidence from AMC CG)
Common Labor DataORGDepot
Unloaded Based Hourly Rate ($)Discuss with Sierra
Productivity Factor %8585Pre-populated but may need to be adjusted
Loading Factor %9045Pre-populated but may need to be adjusted
Effective Labor Rate ($)Non-zero entries override Unloaded Based Hourly Rate
ShippingORG to DEP
Order Ship Time (days)
Military Trans
Cost $/lb.*miOne or the other, but not both
Cost ($/lb.)
Distance (miles)
Global Settings
Turn Around Days
ORG1Pre-populates, but further analysis may be needed.
DSU15
GSU45
Depot180
Echelon Labels
ORGFieldAR 750-1
DepotSustainmentAR 750-1
Contractor Repair AllowedYesDefault

File details come from the government source that posted it. Updated .