6-RFP-08-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet for the City of Fort Worth's RFP for Standard Workwear, providing bidders with instructions for submitting pricing and discount percentages across 34 vendor brands and categories. The RFP seeks proposals for an agreement to supply standard workwear to City departments on an as-needed basis, covering major apparel manufacturers and uniform suppliers including Adidas, Nike, Carhartt, Dickies, Cintas, UniFirst, and other regional and national brands. Bidders must complete the pricing submission by providing unit price amounts in the designated cells (F6-F39) and discount percentages; the spreadsheet contains embedded formulas in purple-labeled charts to automatically calculate discounted pricing based on submitted percentages. Each of the 34 line items is listed with a unit of measure designated as "DO" (likely "Delivered Order" or similar) and a base quantity of $30,000.00 per category.

Bidders are required to fill in all requested pricing information accurately, with clear warnings that incomplete or incorrectly formatted submissions will result in bids being deemed non-responsive. Vendors who do not provide services for specific categories must select "no bid" on the corresponding bid table (BT-39FK) rather than leaving fields blank. The spreadsheet emphasizes that all unit prices must be transferred to Bid Table BT-39FK for proper evaluation, and bidders should avoid entering negative numbers or negative percentages in their discount calculations. This pricing structure allows the City to evaluate multiple vendor options across diverse workwear categories while maintaining standardized discount calculations for comparison purposes.