2-RFQt-05-Discount Calculator.xlsx

This is a discount calculator spreadsheet for the City of Fort Worth, Texas, related to a Request for Quotation (RFQt) for Landscape Irrigation Services needed by the Water Department on an as-needed basis. The spreadsheet provides bidders with instructions for submitting pricing information and calculating discounts on repair parts. Bidders are required to complete the discount percentage and unit price fields in the designated cells, which will automatically populate related calculation charts marked in purple. The line item requests pricing for Parts for Repairs with a specified quantity of $15,000.00.

Bidders must provide accurate pricing and discount percentage information as specified in the instructions, with the unit price amount to be entered in Cell F6 and submitted to Bid Table BT-89PX, line #1-1. All requested information must be completed; failure to do so will result in a non-responsive bid determination. Bidders who cannot provide the requested services should indicate "no bid" on Bid Table BT-89PX. The spreadsheet explicitly prohibits the inclusion of negative numbers or negative percentages in the calculations, and any discrepancies between the spreadsheet calculations and the bid table submission may render the bid non-responsive.