HC102821R0018-Final Revised CLIN Pricing Worksheet_DP.xlsx

XLSX spreadsheet 107 KB Posted

Attached to
Condenser Water Filtration System Upgrade Federal contract opportunity
Solicitation number
HC102821R0018
Issued by
Defense Information Systems Agency

About this file

This document contains a request for proposal template and instructions for upgrading a condenser water filtration and piping system. The Defense Information Systems Agency is seeking proposals to enhance cooling towers, replace piping, adjust water pumps and filtration controls, and provide temporary chillers for redundancy testing at its facility in San Antonio, Texas. The contractor must meet DOD standards to improve reliability, energy use, and redundancy of the IT mechanical system. A site visit is available on March 31st, with questions due by April 9th. The template requires bidders to provide labor categories and rates, material costs, and a price summary in fixed-price contract line item numbers for the upgrades, travel expenses, and optional additions. Indirect and direct rates must be included to support proposed pricing in the submission.

View the file

Other files for this federal contract opportunity

Other files attached to Condenser Water Filtration System Upgrade, newest first.
File Type Posted
HC102821R00180010.pdf PDF
Updated HC102821R0018-PaymentPlan.xlsx XLSX spreadsheet
HC102821R00180009.pdf PDF
QandA.xlsx XLSX spreadsheet
HC102821R00180007.pdf PDF
QandA on WaterFiltration Upgrade.xlsx XLSX spreadsheet
HC102821R00180006.pdf PDF
HC102821R0018-Payment Plan.xlsx XLSX spreadsheet
HC102821R00180003.pdf PDF
183144S-eTCX-0210-SRV.pdf PDF
HC102821R00180002.pdf PDF
Q and A on Water Filtration Upgrade.xlsx XLSX spreadsheet
IMG_1627.JPG JPG image
IMG_1618.JPG JPG image
IMG_1620.JPG JPG image
IMG_1614.JPG JPG image
IMG_1601.JPG JPG image
IMG_1602.JPG JPG image
IMG_1594.JPG JPG image
IMG_1586.JPG JPG image
IMG_1574.JPG JPG image
HC102821R00180001.pdf PDF
IMG_1624.JPG JPG image
IMG_1626.JPG JPG image
IMG_1625.JPG JPG image
IMG_1616.JPG JPG image
IMG_1612.JPG JPG image
IMG_1611.JPG JPG image
IMG_1606.JPG JPG image
IMG_1605.JPG JPG image
IMG_1608.JPG JPG image
IMG_1597.JPG JPG image
IMG_1591.JPG JPG image
IMG_1592.JPG JPG image
IMG_1588.JPG JPG image
IMG_1584.JPG JPG image
IMG_1582.JPG JPG image
IMG_1579.JPG JPG image
IMG_1576.JPG JPG image
IMG_1623.JPG JPG image
IMG_1621.JPG JPG image
Appendix C - Pump Submittal Example.pdf PDF
encl 4_qasp - SAT CW Filtration and Upgrades.pdf PDF
Appendix J - Labeling Specification.docx DOCX document
Appendix R - Temporary Chiller Connection Point Drawing.pdf PDF
Appendix G - ASHRAE Standard 202 - 2013.pdf PDF
Appendix E - VFD Specification.docx DOCX document
HC102821R0018-CLIN Pricing Worksheet.xlsx XLSX spreadsheet
Appendix A - Mechanical Drawing Set (FOUO).pdf PDF
Appendix Q - Contractor NDA.docx DOCX document
Show all 50

Condenser Water Filtration System Upgrade 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

Defense Information Systems Agency (DISA)
Proposal Template

GENERAL INFORMATION

The Government template is for guidance purposes, and is not all inclusive. This template serves as an illustration of the format and details required to complete the Government cost/price evaluation.
The Offeror is responsible to ensure compliance with federal regulations and provide the necessary data as required by the request for proposal/quotation (RFP/RFQ).

Offeror shall complete the Government issued template as instructed:

1) Complete the CLIN Summary and all corresponding sheets.
The Government must be able to verify and track all proposed pricing from the proposed details through to the CLIN Summary.
All links to the corresponding sheet/cells shall be made/linked prior to submitting a proposal
Note, that it is the Offeror's responsibility to ensure the calculations are correct.

2) The spreadsheet shall include all formulas.

3) The Offeror shall provide the required detailed as instructed in the RFP/RFQ.

4) The Contractor shall not include any "pricing notes" in the proposal template.

5) The Offeror can add additional rows/columns or tabs in the template as necessary.
If additional tabs are necessary to reflect further details, the costs on subordinate tabs shall roll up to the appriopriate sheets.
In addition, the Offeror can provide supporting documentation through an attachment if required. The information provided shall allow traceability between the proposed price included in the cost/price template and any provided source information.
6) The offeror is required to provide fully burdened rates. The CLIN Pricing Spreadsheet has highlighted columns that have to be filled out otherwise proposal will be determined to be technically unacceptable.

CLIN Summary

Defense Information Systems Agency (DISA)
Proposal Template
COMPLETE THE FOLLOWING:
Solicitation TitleWater Condenser and Filtration Upgrade
Solicitation NumberHC102821R0018
Contractor Name
Cage Code
Contract Vehicle
Date
CLIN STRUCTURE SUMMARY
CLIN NumberCLIN DescriptionContract TypeBase Period LaborMaterialsTotal Price Subtotal6-Month Ext*Total Price
0001Water Condenser Filtration UpgradesFixed Price$0.00$0.00$0.00$0.00$0.00
0002TravelCost$75,000.00$37,500.00$112,500.00
0003 (OPTIONAL)Optional CLIN - Cat WalksFixed Price$0.00$0.00$0.00$0.00$0.00
0004 (OPTIONAL)Optional CLIN - Crane JIBSFixed Price$0.00$0.00$0.00$0.00$0.00
Subtotal:$0.00$0.00$75,000.00$37,500.00$112,500.00
9999**Surge (Cost Reimbursable NTE)5%$0.00$0.00$3,750.00$3,750.00
TOTAL EVALUATED PRICE:$116,250.00

NOTE 1: *6-Month Extension - For Evaluation Purposes only. Provide pricing for Optional 6-month extension authorized in accordance with FAR 52.217-8. CLIN(s) will not appear on contract. Assume all previous option periods have been exercised. DO NOT INCLUDE SURGE CLIN PRICING IN THIS NUMBER.

NOTE 2: **Surge CLIN OF ALL BASE PERIOD and OPTION PERIOD CLINs, excluding 6-mo extension authorized IAW FAR 52.217-8, see subtotal above). Surge CLINs are Cost Reimbursable (CR) Not to exceed (NTE).

NOTE: 3: This requriement is Firm Fixed Price requirement so the total has to include labor, material costs and Other Directed Costs. There is a separate CLIN for travel.

BP (FFP with Labor Breakout)

Defense Information Systems Agency (DISA)
Proposal Template
Base Period
FFP Labor (with labor rate breakdown)Rate BuildTotals
CLIN #Company Name (Prime/Sub)PWS/SOW Task(s)Labor Category #Proposed Contract Labor CategoryMapped Internal Labor CategoryGovernment Site /Contractor SitePrime Direct Hrly RateSubcontract Hrly RateIndirect 1Indirect 2Indirect 3Indirect 4Indirect 5Indirect 6Proposed Labor Hr CostFixed FeeProposed Fully Burdened Labor Hr RateProposed Labor HoursTotal Direct Labor CostTotal Subcontract CostTotal Indirect 1Total Indirect 2Total Indirect 3Total Indirect 4Total Indirect 5Total Indirect 6Total CostTotal Fixed FeeAmount
(if applicable)(if applicable)0%0%0%0%0%0%0%(Column H * S)(Column I * S)(Column J * S)(Column K * S)(Column L * S)(Column M * S)(Column N * S)(Column O * S)(Column P * S)(Column Q * S)(Column R * S)
x001Laborer
x001Carpenter
x001Electrician
x001Electronics Technician
x001Plumber
x001Pipefitter
x001Welder
ADD ADDITIONAL ROWS IF NECESSARY
Total FFP Labor (CLIN X001)$ - 0
x003Laborer
x003Carpenter
x003Electrician
x003Electronics Technician
x003Plumber
x003Pipefitter
x003Welder
ADD ADDITIONAL ROWS IF NECESSARY
Total FFP Labor (CLIN X003)$ - 0
x004Laborer
x004Carpenter
x004Electrician
x004Electronics Technician
x004Plumber
x004Pipefitter
x004Welder
ADD ADDITIONAL ROWS IF NECESSARY
Total FFP Labor (CLIN X004)$ - 0

Total FFP Price $ - 0

InstructionsProvide detailed cost build-up by contract period—including all source information (i.e. direct and indirect rates), formulas and calculations—to support proposed labor rates for each of the labor categories.
NOTE 1:All proposed Materials/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

NOTE 2: All hightlighed full burdened categories above have to be filled out (even if zero) or the government may determine that the submitted proposal is not technically acceptable.

**COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER**

Materials
CLINOEM/Vendor SourcePWS/SOW TaskPart NumberProposed ItemDescriptionUnit CostQuantitySub TotalApplicable IndirectApplicable IndirectTotalSupportingSupporting
0%0%Basis of RateData Reference
CLIN x001 Materials
x001(e.g. invoices, price history, etc)(e.g. Tab A, attachment xyz)
x001
x001
x001
x001
x001
x001
ADD ADDITIONAL ROWS IF NECESSARY
Total Materials (CLIN X001)$ - 0
CLIN x003 Materials
x003
x003
x003
x003
x003
x003
x003
ADD ADDITIONAL ROWS IF NECESSARY
Total Materials (CLIN X003)$ - 0
CLIN x004 Materials
x004
x004
x004
x004
x004
x004
x004
ADD ADDITIONAL ROWS IF NECESSARY
Total Materials (CLIN X004)$ - 0

Total Material Cost - 0

Travel Cost
CLINLocations (To and From)Number of DaysNumber of PersonnelMeals and IncidentalsLodgingAirfareRental CarOtherTotalApplicable IndirectTotalSupportingSupporting
0%Basis of RateData Reference
0002GOVERNMENT PROVIED NUMBER$ 75,000.00$ - 0$ 75,000.00(e.g. GSA detail, commercial pricing, etc)(e.g. Tab A, attachment xyz)
75,000
Other Direct Costs
TBDTBDTBDTBDTBDTBDTBDTBDTBDTotalApplicable IndirectTotalSupportingSupporting
0%Basis of RateData Reference
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
ADD ADDITIONAL ROWS IF NECESSARY$ - 0$ - 0$ - 0
- 0

FP Rate Sheet

Defense Information Systems Agency (DISA)
Proposal Template
Contract/Schedule Labor RatesBlended Contract/Schedule Rate (if necessary)
Year 1Year 2Year 3Year 4Year 5BPOP1OP2OP3OP4
Labor CategoryMapped Labor CategoryGovernment Site/Contractor SiteRateRateRateRateRateRateRateRateRateRate
Prime Labor

Subcontracting Labor

Instructions:Provide all proposed FP labor rates for each of the labor category.
Add additional columns/rows if needed. For example, the offeror can illustrate a blended rate between periods.

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