8-RFP-08-Discount Calculator.xlsx

This is a discount calculator spreadsheet for the City of Fort Worth's Request for Proposal for Water Meters & Appurtenances, located in Texas. The document provides bidders with instructions for submitting pricing information and discount percentages for parts and repairs services. Bidders must complete the line item pricing for Parts for Repairs (Item #1-102) by providing both a discount percentage and a unit price. The spreadsheet contains automated calculation formulas, highlighted in purple, that will populate discount pricing information based on the percentages and unit prices entered by vendors. Bidders are required to transfer their calculated unit price from this spreadsheet to Bid Table BT-28GU, Line #1-102. The document emphasizes that all requested information must be completed accurately; failure to properly fill in the pricing information will result in the bid being deemed non-responsive. If a company does not provide the requested services, bidders must select "no bid" on Bid Table BT-28GU.

The Parts for Repairs line item is based on a quantity of one with a required dollar amount of $15,000.00. Bidders must ensure that no negative numbers or negative percentages are included in their submissions. The spreadsheet serves as a calculation tool to facilitate transparent pricing evaluation, with the final unit price being the critical figure for contract award consideration. This pricing mechanism appears designed to allow the City of Fort Worth to assess and compare discount structures across multiple bidders for parts and repair services provided on an as-needed basis.