2-RFQt-04-Discount Calculator.xlsx

This is a discount calculation worksheet supporting an RFQt (Request for Quotation) for kitchen equipment repair services issued by the City of Fort Worth, Texas. The bidding document provides vendors with a standardized tool to calculate discounted pricing for repair parts on an as-needed basis. The worksheet requires bidders to input their percentage discount offering, which automatically recalculates the unit price through embedded formulas. Bidders must then transfer the calculated unit price from the discount calculator to Bid Table BT-26BW for line items 1-5.

The base price for parts for repairs is established at $5,000.00 per each (EA) unit of measure. Bidders should enter only whole number percentages without negative values in the designated discount cell. The calculated unit price resulting from the discount formula must be used as the final bid price submitted in Bid Table BT-26BW. This pricing structure applies uniformly across all five line items in the bid table, ensuring consistency in discount application across the quoted repair services.