8-RFP-08-Discount Calculator.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
RFP Water Meters & Appurtenances
Solicitation number
26-0054
Issued by
Tarrant County, Texas

About this file

This is a discount calculator spreadsheet supporting an RFP issued by the City of Fort Worth, Texas, for Water Meters & Appurtenances to be provided to the Water Department on an "as needed" basis. The spreadsheet is designed to assist bidders in calculating discounted pricing for repair parts. Bidders are required to complete the discount percentage and unit price fields in the calculator; the spreadsheet will automatically populate related calculations in designated cells. All requested information must be completed accurately, with bidders providing their final unit price amount to Bid Table BT-24PX line #1-102.

The line item included is Parts for Repairs with a designated order of magnitude (DO) of $15,000.00. Bidders must enter both a discount percentage and unit price in the specified cells; failure to correctly complete and transfer this information to Bid Table BT-24PX will result in the bid being deemed non-responsive. Bidders who do not provide these services must select "no bid" on the bid table. The spreadsheet explicitly prohibits the entry of negative numbers or negative percentages in the discount calculation fields.

View the file

Other files

File Type Posted
4-RFP-03-Authorized Signature and Questionnaire.pdf PDF
5-RFP-04-Draft Vendor Service Agreement.pdf PDF
2-RFP-01-Instruction to Proposers.pdf PDF
6-RFP-06-Deviations.xlsx XLSX spreadsheet
3-RFP-02-Scope of Services.pdf PDF
1-RFP-05-Forms.pdf PDF
7-RFP-07-Reference Sheet.pdf PDF

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

Sheet1

Discount Calculation
Instructions: Bidder shall provide pricing and percentages on the line item below. By filling out the percentages below, the charts labeled in purple will begin to be filled out by using formulas (Please do not include negative numbers or negative percentages). For evaluation purposes, the charts labeled in purple is to help vendors calculate their discount pricing. Please provide the unit price amount below to Bid Table BT-24PX. Please note that all information requested shall be filled in. If your company does not provide these services, please select no bid on Bid Table BT-24PX. If the information on this spreadsheet is incorrectly filled in to the bid table, your bid will be deemed non-responsive.
Please provide the Unit Price in Cell F6 to Bid Table BT-24PX line #1-102
#ItemUOMQuantity RequiredDiscount PercentageUnit Price
#1-102Parts for Repairs, Discount PercentageDO$15,000.00$15,000.00

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