4-RFP-08-Discount Calculator.xlsx

This is a discount calculator spreadsheet supporting the City of Fort Worth's RFP for traffic signal poles and arms for the Transportation and Public Works Department. The RFP seeks proposals to establish non-exclusive agreements for these products on an as-needed basis. The calculator spreadsheet requires bidders to provide pricing information and discount percentages for two line items: Product - COFW Specification Items (Item #1-1) and Product - TXDOT Specification Items (Item #1-2), each with a base unit price of $10,000.00 and a quantity measured in percent. The spreadsheet utilizes automated formulas to calculate discounted pricing based on the percentages entered by bidders.

Bidders must complete the discount calculator by providing unit prices and discount percentages for both specification items, which will then populate the corresponding Bid Table BT-13IU entries. The instructions explicitly state that all requested information must be completed and that negative numbers or negative percentages should not be included. If a company does not provide these services, it must select "no bid" on Bid Table BT-13IU. Incorrect completion of the spreadsheet that results in mismatched information between the calculator and the bid table may result in the bid being deemed non-responsive. This document serves as a pricing tool to ensure consistent and transparent discount calculations across all submitted proposals.