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

This document is a Discount and Markup Calculator spreadsheet associated with a Request for Proposal (RFP) from the City of Fort Worth for Industrial Electrical Services for the Water Department. The RFP requires bidders to provide detailed pricing and percentage calculations for parts and repairs, specifically requesting a unit price for parts repairs with a corresponding discount percentage. The spreadsheet provides instructions for vendors to calculate and submit pricing, emphasizing that incomplete or incorrectly filled information may result in a non-responsive bid.

The pricing mechanism involves bidders submitting a unit price and discount percentage for a total potential parts repair value of $15,000. The document stresses the importance of accurate completion, noting that vendors must either provide complete pricing information or select a "no bid" option. The calculation sheet includes formulas to help vendors compute their discount and markup pricing, with a specific requirement to avoid negative numbers or percentages. The opportunity is located in Texas and is structured as an "as needed" agreement, suggesting flexible service engagement for the City of Fort Worth's Water Department.