8-ITB-08-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet for the City of Fort Worth's Invitation to Bid (ITB) for Bulk Chemicals for the Water Department on an as-needed basis. The document serves as a pricing tool to assist bidders in calculating discounted unit prices for line items included in the procurement. Bidders are required to complete the spreadsheet by providing pricing information and discount percentages, which will automatically populate associated calculation fields marked in purple. The primary line item referenced is Parts for Repairs with a base dollar amount of $15,000.00 and a unit of measure designated as "DO" (likely "Demand Order" or similar designation).

Bidders must accurately complete all requested information on this discount calculator and transfer the calculated unit price from Cell F6 to Bid Table BT-16BE for line #1-102. The instructions explicitly state that if the spreadsheet is incorrectly filled in or transferred to the bid table, the submission will be deemed non-responsive. Bidders who cannot provide the requested services must select "no bid" on Bid Table BT-16BE. No negative numbers or negative percentages are permitted in the discount calculations. The completed pricing information from this spreadsheet is essential for proper bid evaluation and must be integrated into the formal bid submission documents.