9-RFP-09-Discount and Markup Calculator.xlsx

This is a Discount and Markup Calculator spreadsheet for a Request for Proposals issued by the City of Fort Worth, Texas for a Turnkey Emergency Bypass Agreement with the Water Department on an as-needed basis. Bidders are required to complete the pricing calculator by providing discount percentages and unit prices for parts and repairs services. The spreadsheet uses formulas to automatically calculate markup and discount pricing based on the percentages entered by vendors. All requested information must be completed in full, and the calculated unit price from Cell F6 must be transferred to Bid Table BT-59DX for line items 1 through 41. The project involves a baseline parts and repairs budget of $15,000.00.

Bidders who cannot provide the requested services must select "no bid" in Bid Table BT-59DX to avoid bid rejection. If the discount and markup information is not correctly transferred from the calculator to the bid table, the submission will be deemed non-responsive. The spreadsheet serves as a mandatory calculation tool to ensure consistent pricing methodology across all bids and facilitate accurate evaluation of vendor proposals for the emergency bypass services contract.