4-RFQt-04-Discount Calculator.xlsx

This is a Discount Calculator spreadsheet for the City of Fort Worth, Texas's Request for Quotes for Window and Door Glass Replacement services for the Water Department on an "as needed" basis. The calculator is designed to assist bidders in determining their discount pricing for Parts for Repairs. Bidders are required to provide both pricing and discount percentages in the designated cells, with formulas automatically calculating the discount amounts in the purple-highlighted sections of the spreadsheet. The line item for Parts for Repairs shows a quantity of $15,000.00 with a corresponding unit price field. Bidders must complete all requested information and enter their unit price amount in Cell F6, which will be transferred to Bid Table BT-28GU line item #1-102. Any bid submitted with incomplete or incorrectly filled information will be deemed non-responsive. Bidders who do not provide these services must select "no bid" on Bid Table BT-28GU.

The pricing structure requires bidders to calculate and submit discount percentages for Parts for Repairs, with the calculator automatically generating adjusted pricing based on the submitted discounts. Bidders are explicitly instructed not to include negative numbers or negative percentages in their calculations. The spreadsheet serves as both a bidding tool and an evaluation mechanism to standardize vendor discount presentations across all submitted bids for the window and door glass replacement agreement.