1-RFP-08-Discount Calculator.xlsx

This is a Discount and Markup Calculation Instructions spreadsheet prepared for the City of Fort Worth's RFP for Video Games and Related Services, which seeks an agreement with the Library and Park and Recreation Departments operating on an "as needed" basis. The solicitation requests bids for product video games with a quantity requirement of $10,000.00. Bidders are required to complete the discount calculator by providing pricing percentages and unit prices, with calculated results automatically populating in designated purple-highlighted charts to facilitate vendor cost analysis. All information must be accurately completed and transferred to Bid Table BT-46AK, line #1-1, with the unit price cell serving as the primary pricing submission mechanism. Bidders unable to provide these services must select "no bid" on the bid table to avoid non-responsive bid determinations.

The spreadsheet establishes a baseline unit price of $10,000.00 for the video games product line item with a default discount percentage of 0.00%, maintaining the unit price at $10,000.00 unless bidders elect to apply a discount. Bidders must provide their proposed discount percentage and resulting unit price; negative numbers and negative percentages are explicitly prohibited in submissions. Incomplete or incorrectly filled spreadsheet information transferred to the bid table may result in bid rejection for non-responsiveness, emphasizing the critical importance of accurate calculation and submission compliance.