5-RFP-09-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet accompanying an RFP for chemical tanks issued by the City of Fort Worth, Texas Water Department on an "as needed" basis. The document provides bidders with instructions for calculating and submitting discount pricing for Parts for Repairs. Bidders are required to enter discount percentages and unit prices in the designated cells, with formulas automatically calculating the discounted amounts in purple-highlighted chart areas. The spreadsheet indicates a base contract value of $15,000.00 for Parts for Repairs, with bidders instructed to provide their unit price in Cell F6 and submit the corresponding information to Bid Table BT-13MV, lines 1-4. Bidders must complete all requested information or select "no bid" on Bid Table BT-13MV if their company does not provide these services.

Bidders are cautioned that incomplete or incorrect submission of discount pricing information on this spreadsheet will result in their bid being deemed non-responsive. The calculator serves as both a vendor tool for determining their discount pricing strategy and an evaluation instrument for the City of Fort Worth. Negative numbers and negative percentages are explicitly prohibited in the submission. The structure of the discount calculator requires bidders to demonstrate their pricing flexibility and competitive positioning relative to the $15,000.00 baseline for Parts for Repairs services.