10-RFP-08-Discount Calculator.xlsx

This is a discount calculator spreadsheet for the City of Fort Worth's Railroad Inspection and Maintenance RFP for the Water Department. The spreadsheet serves as a tool for bidders to calculate and submit discounted pricing for Parts for Repairs services on an as-needed basis. Bidders are required to input discount percentages and unit prices, which will automatically populate purple-highlighted calculation charts through embedded formulas. The template includes line item #1-31 for Parts for Repairs with a base amount of $15,000.00, and bidders must complete all requested information and transfer their calculated Unit Price to Bid Table BT-46AC. Failure to correctly complete and transfer pricing information to the bid table will result in a non-responsive bid determination.

Bidders who do not provide the requested services must indicate "no bid" on Bid Table BT-46AC. The spreadsheet explicitly prohibits the submission of negative numbers or negative percentages in the discount calculations. This pricing mechanism allows the City to evaluate vendor discounts systematically while ensuring consistent bid formatting and responsiveness across all submissions for this ongoing maintenance and inspection services contract.