8-RFP-09-Discount Calculator.xlsx

This is a Discount Calculator instruction file related to the City of Fort Worth's RFP for Meter Boxes and Lids for the Water Department. The document provides bidders with detailed instructions on how to complete pricing submissions, requiring vendors to submit unit prices and discount percentages for Parts for Repairs line items totaling a base amount of $15,000.00. The spreadsheet utilizes automated formulas to calculate discount and markup pricing once vendors input their discount percentages and unit prices in the designated cells. Bidders must transfer their final unit price information from Cell F6 to Bid Table BT-45IJ for line items 1-16, and all requested information must be completed in full or the bid will be deemed non-responsive.

The pricing structure requires vendors to provide discount percentages applied against the base Parts for Repairs amount, with the spreadsheet calculating resulting values automatically to assist in bid preparation. Vendors who do not provide these services must select "no bid" on Bid Table BT-45IJ to maintain bid responsiveness. The document emphasizes that negative numbers or negative percentages should not be included in submissions, and any discrepancies between the discount calculator spreadsheet and the official Bid Table BT-45IJ will result in bid rejection. This procurement is for the City of Fort Worth, Texas, seeking an agreement on an "as needed" basis for meter box and lid supplies and services.