2-RFP-09-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet submitted as part of a Request for Proposals (RFP) issued by the City of Fort Worth, Texas, for Hydrovac Waste Material services to support the Water Department on an as-needed basis. The spreadsheet serves as a pricing tool requiring bidders to provide unit prices and discount percentages for line items related to parts for repairs. Bidders must complete all requested information in the calculator, with the spreadsheet utilizing formulas to automatically calculate discount and markup pricing in designated purple-highlighted cells. The calculated unit price must be transferred to Bid Table BT-O5FQ for formal submission.

The pricing structure requires bidders to input a unit price amount in Cell F6 of the discount calculator for submission to Bid Table BT-O5FQ line items #1-4, with a baseline amount of $15,000.00 referenced for parts for repairs. Bidders must provide discount percentages without including negative numbers or negative percentages. The RFP specifies that all information must be accurately and completely filled in; any incorrect information transferred to the bid table will result in the bid being deemed non-responsive. Bidders who cannot provide the requested services must select "no bid" on Bid Table BT-O5FQ rather than submitting incomplete pricing information.