2-RFP-09-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet supporting an RFP for Residential Plumbing Services issued by the City of Fort Worth, Texas, for the Water Department on an "as needed" basis. The spreadsheet provides bidders with a standardized template to calculate and submit pricing for repair parts and services. Bidders are required to complete the discount percentage and unit price fields, with the calculator automatically generating related pricing formulas in designated purple-highlighted cells. The spreadsheet specifies that bidders must provide all requested information and submit unit pricing in Cell F6 to Bid Table BT-02BV line item #1-191. Bidders who do not provide these services must select "no bid" on the bid table, and any incorrect completion of the spreadsheet will result in the bid being deemed non-responsive.

The discount calculator identifies a baseline parts requirement of $15,000.00, with bidders required to submit their discount percentage and resulting unit price for the repair parts line item. The spreadsheet explicitly prohibits negative numbers or negative percentages in the calculations. All information must be accurately transferred to Bid Table BT-02BV for bid evaluation purposes. Bidders should note that the purple-highlighted calculation charts are provided as tools to verify their discount and markup pricing before final submission to the bid table.