1-RFP-08-Discount Calculator.xlsx

This is a discount calculator instruction document for the City of Fort Worth, Texas, in support of an Irrigation and Grounds Maintenance Services and Repairs agreement for the Park and Recreation Department. The document provides bidders with a standardized spreadsheet template to submit pricing for parts, repairs, components, and accessories related to grounds maintenance and irrigation services on an "as needed" basis. Bidders are required to complete all requested information, including discount percentages and unit prices, with the understanding that incomplete or incorrectly filled submissions may result in non-responsive bids. The calculator includes two primary line items: Parts and Repairs with a discount off MSRP and Components and Accessories, each with a reference amount of $10,000.00.

Bidders must provide discount percentages and corresponding unit prices in the designated cells, which will automatically populate related calculation fields through embedded formulas. The spreadsheet explicitly prohibits negative numbers or negative percentages in submissions. All calculated unit price amounts must be transferred to Bid Table BT-39OZ for formal evaluation purposes. Bidders unable to provide the requested services or pricing information must indicate "no bid" on Bid Table BT-39OZ. The pricing structure is based on a discount methodology rather than fixed costs, allowing the City to leverage negotiated percentage reductions from manufacturer's suggested retail prices for parts and components procured throughout the contract term.