5-RFP-08-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet accompanying an RFP for Sewer Cleaning Equipment issued by the City of Fort Worth, Texas Water Department on an "as needed" basis. Bidders are required to complete the discount calculation worksheet by providing pricing and discount percentages for line items. The spreadsheet contains formulas in designated purple-highlighted sections that automatically calculate discounted pricing based on the percentages entered by vendors. Bidders must provide a unit price amount in Cell F6 and submit all required information to Bid Table BT-46HS for RFP 26-0140. The calculator lists a baseline item with a unit price of $15.00, though vendors may submit pricing for items not listed by entering appropriate discount percentages.

Bidders who do not provide the services requested must select "no bid" on Bid Table BT-46HS. The instructions emphasize that all information must be accurately completed and that negative numbers or negative percentages should not be included. Failure to correctly fill in the spreadsheet information will result in the bid being deemed non-responsive. The spreadsheet serves as a critical evaluation tool for vendors to demonstrate their pricing structure and discount calculations for the City's consideration during the procurement process.