Attachment_0040_Pricing_Workbookv2 (4 Jun 21).xlsx

XLSX spreadsheet 42 KB Posted

Attached to
Water Storage Distribution System (Solicitation) Federal contract opportunity
Solicitation number
W56HZV21R0011
Issued by
Department of the Army Materiel Command TACOM Life Cycle Management Command

About this file

This document includes an attachment to a federal solicitation and the related solicitation details. The solicitation seeks proposals to procure Water Storage Distribution Systems to provide large-scale potable water storage and distribution capabilities. Key requirements include the integration, assembly, and logistics support for up to 123 Water Storage Distribution Systems with capacities of 100,000 gallons or split 50,000 gallon configurations, as well as an option for up to 150 spare 350 GPM fluid distribution pumps. The U.S. Army Contracting Command-Detroit Arsenal intends to award up to five IDIQ contracts initially for test articles, then downselect to a single provider for production orders over a five-year base period and two additional option years as a 100% small business set-aside. The attachment provides a pricing workbook for offerors to complete proposed pricing for the production quantities and option years.

View the file

Other files for this federal contract opportunity

Other files attached to Water Storage Distribution System (Solicitation), newest first.
File Type Posted
WSDS QA 91-95.pdf PDF
Attachment 0010 SESAME.xlsx XLSX spreadsheet
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_0042_Pricing_Workbookv2.xlsx XLSX spreadsheet
Notice to Offerors.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
Instructions.docx DOCX document
Copy of Attachment 0042 - Updated Pricing Workbook.xlsx XLSX spreadsheet
Attachment 0039 - Copyright Release Letter Template.docx DOCX document
Attachment 0037 PKG1_LPD Coded Data Products Packaging.docx DOCX document
Attachment 0026-IADS Dataset_TOC File Template.docx DOCX document
Attachment 0017- AMPS Procedures for Users and Administrators.pdf PDF
Copy of Attachment 0010-SESAME.xlsx XLSX spreadsheet
Attachment 0007 - WSDS Technical Data Package (TDP).zip ZIP file
Attachment 0006- CARC Paint Drawing 12585018.pdf PDF
Attachment 0024-TPG 2016-01 Rev 1 Source Data.pdf PDF
Attachment 0038_Technical Review Criteria.docx DOCX document
Attachment 0034- Additional Guidelines for Controlled Unclassified Information.docx DOCX document
Attachment 0033- Department of Defense Guide to Item Unique Identification Quality Assurance.doc DOC document
Attachment 0029- Provisioning Requirements Worksheet.docx DOCX document
Attachment 0011- LPD Attribute Selection Sheet.pdf PDF
Copy of Attachment 0005- HMMR Format.XLSX XLSX spreadsheet
Attachment 0004- Request for Use of Prohibited Materials.doc DOC document
Attachment 0002-PEO CSCSS OPSEC Program.pdf PDF
Attachment 0028-SSI.DOCX DOCX document
Attachment 0027-ATPD 2232 Packaging.pdf PDF
Attachment 0025-TM Crosswalk Form.xls XLS spreadsheet
Copy of Attachment 0015-LORA.xlsx XLSX spreadsheet
Attachment 0013-GMTK CL.pdf PDF
Attachment 0003 - ATPD-2425 WSDS.pdf PDF
Solicitation WSDS.pdf PDF
Attachment 0009- Failure Definition and Scoring Criteria (FDSC).docx DOCX document
Attachment 0018-DE Style Guide 1-26-18.pdf PDF
Copy of Attachment 0041 - Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Copy of Attachment 0040 - Pricing Workbook revised 4 20 2021.xlsx XLSX spreadsheet
Attachment 0036- Incoming Transaction Format Packaging.docx DOCX document
Attachment 0035- MOS Operator and Maintenance Tasks 92W-91J.docx DOCX document
Attachment 0032- IUID Data Plate Examples.docx DOCX document
Attachment 0031-Microscan UID Compliance Results.pdf PDF
Attachment 0030 - Pump Reliability and Mobility PQT Plan WSDS-v16.docx DOCX document
Attachment 0023-General Publications Requirements for Page-Based Manuals.doc DOC 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 0021-TABLE A-VI - TM Requirements Matrix -23P RPSTL.DOCX DOCX document
Show all 50

Water Storage Distribution System (Solicitation) has more files on GovTribe.

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

Solicitation W56HZV-21-R-0022
Attachment 0040 - Pricing Workbook
Instructions
1) Cells that require inputs are highlighted in yellow
2) All cells that are highlighted in yellow must be completed
3) Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4) The required inputs are used to auto calculate the Total Proposed Price on the "summary" Worksheet.
5) Do not make any changes or modifications to this attachment except for those cells highlighted in yellow

Summary

Price Attachment 0040
Solicitation W56HZV-21-R-0011
Price Summary
Offeror:
[Type offeror name here]

Total Proposed Price

DescriptionAmount
WSDS 100k Production CLINs$0
WSDS 100k Option CLINs$0
WSDS 100k Production with Split Operations CLINs$0
WSDS 100k Production with Split Operations Option CLINs$0
Storage CLINs$0
Storage Option CLINs$0
350 GPM Fuel Pump Production CLINs$0
350 GPM Fuel Pump Option CLINs$0
350 GPM Water Pump Production CLINs$0
350 GPM Water Pump Option CLINs$0
50K Water Storage Bag Production CLIN$0
50K Water Storage Bag Production Option CLINs$0
Authorized Stockage List CLIN$0
Authorized Stockage List Option CLINs$0
CLINs 0001-0005$0
Seperately Priced CDRLs$0
Total Proposed Price$0

Production CLINS

Offeror:
[Type offeror name here]

Firm Fixed Price

WSDS 100k Production CLINsCLIN 1001 - Production Yr 1CLIN 2001 - Production Yr 2CLIN 3001 - Production Yr 3CLIN 4001 Production Yr 4CLIN 5001 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty3624453
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
WSDS 100k Option CLINsCLIN 6001 - Option Yr 1CLIN 7001 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty33
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

WSDS 100kw/ Split Operations Production CLINsCLIN 1002 - Production Yr 1CLIN 2002 - Production Yr 2CLIN 3002 - Production Yr 3CLIN 4002 Production Yr 4CLIN 5002 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty3121122
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
WSDS 100k w/Split Operations Option CLINsCLIN 6002 - Option Yr 1CLIN 7002 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty22
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

Storage CLINsCLIN 1003 - Storage Ordering Yr 1CLIN 2003 - Storage Ordering Yr 2CLIN 3003 - Storage Ordering Yr 3CLIN 4003 - Storage Ordering Yr 4CLIN 5003 - Storage Ordering Yr 5
AmountAmountAmountAmountAmount
Per Unit
Days1801801803030
Proposed Qty5030303030
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
Storage Option CLINsCLIN 6003 - Storage Option Yr 1CLIN 7003 - Storage Option Yr 2
AmountAmount
Per Unit
Days3030
Proposed Qty3030
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

350 GPM Fuel Pump Production CLINsCLIN 1004 - Production Yr 1CLIN 2004 - Production Yr 2CLIN 3004 - Production Yr 3CLIN 4004 Production Yr 4CLIN 5004 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty1613131311
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
350 GPM Fuel Pump Option CLINsCLIN 6004 - Option Yr 1CLIN 7004 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty22
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

350 GPM Water Pump Production CLINsCLIN 1005 - Production Yr 1CLIN 2005 - Production Yr 2CLIN 3005 - Production Yr 3CLIN 4005 Production Yr 4CLIN 5005 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty43332
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
350 GPM Water Pump Option CLINsCLIN 6005 - Option Yr 1CLIN 7005 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty22
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

50K Water Storage Bag Production CLINCLIN 1006 - Production Yr 1CLIN 2006 - Production Yr 2CLIN 3006 - Production Yr 3CLIN 4006 Production Yr 4CLIN 5006 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty55555
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
50K Water Storage Bag Production Option CLINsCLIN 6006 - Option Yr 1CLIN 7006 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty22
Proposed CLIN Price$ - 0$ - 0

Firm Fixed Price

Authorized Stockage List CLINCLIN 1007 - Production Yr 1CLIN 2007 - Production Yr 2CLIN 3007 - Production Yr 3CLIN 4007 Production Yr 4CLIN 5007 - Production Yr 5
AmountAmountAmountAmountAmount
Per Unit
Proposed Qty55555
Proposed CLIN Price$ - 0$ - 0$ - 0$ - 0$ - 0
Authorized Stockage List Option CLINsCLIN 6007 - Option Yr 1CLIN 7007 - Option Yr 2
AmountAmount
Per Unit
Proposed Qty22
Proposed CLIN Price$ - 0$ - 0

Non Production CLINS

Offeror:Yes
[Type offeror name here]No

CLIN Description Unit Price Days Quantity Unit of Measure Proposed Extended Price

0001WSDS Pump Reliability and Mobility Phase I4EA$ - 0
0002Pump Reliability and Mobility FSR Support- Phase I1LO$ - 0
0003WSDS PQT (System Level) Phase II2LO$ - 0
0004PQT Test FSR Support -APG Phase II1LO$ - 0
0005Refurbish Production Representtive Articles - PQT Phase II2LO$ - 0
Total Proposed Price - CDRLs 0001-0005$ - 0

CDRL Description Quantity Unit of Measure Proposed Unit Price

L00213&P Operator and Field Maintenance Manual including RPSTL for 350 GPM Pump1LO
L008-10 Operator Manual1LO
L009-23 Maintenance Manual1LO
L010-23 Repair Parts and Special Tools List (RPSTL)1LO
L011NMWR with RPSTL1LO
L016Training Support Package1LO
L021IMDP & Multimedia Instruction 3D DTE1LO
L02213&P Operator & Field Maintenance W/RPSTL - WSDS1LO
L023IMI1LO
L024Source Files1LO
Total Proposed Price - Seperately Priced CDRLs$ - 0
Not Seperately Priced CDRLs
CDRLDescriptionQuantityUnit of MeasureProposed

Extended Price

P001Meeting Agenda and Read-Ahead Packages1LONSP
P002Conference Minutes-Meeting Minutes1LONSP
P003Reserved1LONSP
P004System Safety Program Plan (SSPP)1LONSP
P005Safety Assessment Report1LONSP
P006Human Factors Engineering Analysis1LONSP
P007Hazardous Materials Management Report (HMMR)1LONSP
P008Inspection and Test Plan -ECP-NOR, VECP1LONSP
P009Request for Variations (RFV), Request for Deviation, Request for Waiver1LONSP
P010Suppliers Configuration Management Plan1LONSP
P011Configuration Status Accounting (CSA) Information -CSA Report1LONSP
P012Failure Analysis and Corrective Action Report (FACAR)1LONSP
P013Reserved1LONSP
P014Reserved1LONSP
P015Configuration Audit Summary Report and Certification- Physical Configuration Audit (PCA) Summary Report1LONSP
P016Technical Data package (TDP) and Engineering Release Record1LONSP
P017Inspection and Test Plan (AI&T)1LONSP
P018Assessment of Arsenal Manufacturing Capability1LONSP
P019Reserved1LONSP
P020Technical Review Criteria1LONSP
P021Risk Management Plan1LONSP
L001Reliability Centered Maintenance1LONSP
L003Product Support Analysis Plan1LONSP
L004Logistic Product Data1LONSP
L005Diminishing Manufacturing Sources and Material Shortages1LONSP
L006Provisioning Technical Documentation1LONSP
L007Equipment Publications Developmental Status Report1LONSP
L012TM Crosswalk Report1LONSP
L013Technical Manual Quality Assurance Program Plan1LONSP
L014Validation Plan1LONSP
L015Validation Report1LONSP
L017Packaging Logistics Product Data1LONSP
L018Special Packaging Instruction1LONSP
L019Commercial Off The Shelf Manuals and Associated Supplemental Data1LONSP
L020Item Unique Identification1LONSP

Sheet1

Attachment 0032RFP
ERROR:#REF!ERROR:#REF!ERROR:#REF!TECHNICAL DATA PACKAGE
0009ERROR:#REF!0009DATA ITEMS - CDRLS
A003Test Readiness Review (TRR) ReportA003DRIP
A006Human Factors Engineering Analysis (HFEA)A006HUMAN ENGINEERING DESIGN APPROCH DOCUMENT
A015Technical Data Package (TDP)A015PRODUCT GOV FORMAT TDP
A016Technical Data Package (TDP) Validation PlanA016TDP VALIDATION PLAN
A017Technical Data Package (TDP) Review ReportA017VALIDATION REPORT
A018Demonstration of Acceptance, Inspection and Test (AI&T) PlanA018INSPECTION AND TEST PLAN (AI&T)
A019Transportability ReportA019REPORT
A020Producibility Analysis ReportA020ASSESSMENT OF ARSENAL MANUFACTURING CAPABILITY
L001Product Support Analysis Plan (PSAP)L001PREPARATION OF PRODUCT SUPPORT ANALYSIS PLAN (PSAP)
P005Technical Manual Validation PlanP005VALIDATION PLAN
L008Packaging Logistics Product DataL008TECHNICAL MANUAL QUALITY ASSURANCE (TMQA) PROGR
L006Training Support PackageL006VALIDATION REPORT
L005Diminishing Manufacturing Sources and Material Shortages (DMSMS) ManagementL005VALIDATION PLAN
P00323P Field Maintenance Repair Parts and Special Tools List (RPSTL) ManualP003FIELD MAINTENCE REPAIR PATS & SPECIAL TOOLS LIST
P004National Maintenance Work Requirement with Repair Parts and Special Tools List (RPSTL) (OPTION)P004NATIONAL MAINTENCE WORK REUIREMENT WITH REPAIR

Also I have: CLINs A001-A022 & P007 -P008 as NSP CLINs

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