9-RFP-09-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet for an RFP issued by the City of Fort Worth, Texas, seeking proposals for lab supplies to support the Water Department on an as-needed basis. The RFP solicits pricing for fifteen line items across six categories of laboratory equipment and materials, including microscopes, beakers, test tubes, personal protective equipment (gloves, lab coats, safety goggles), graduated cylinders, measuring cups, chemical solvents, acids, bases, and various types of tubes and flasks. All items are listed with a unit of measure designated as "DO" (Dozens) and a base unit price of $15,000.00 per item.

Bidders are required to complete the spreadsheet by providing discount percentages and unit prices for each line item in Cell F6, which will then be automatically calculated in purple-highlighted cells using formulas. The completed pricing information must be transferred to Bid Table BT-28PY, with line items numbered 1-13 corresponding to the products listed. Bidders must fill in all requested information or select "no bid" if they cannot provide the services; failure to correctly complete and transfer pricing information to the bid table will result in a non-responsive bid determination. The spreadsheet emphasizes that negative numbers or negative percentages should not be included in the submission.