9-RFP-09-Discount and Markup Calculator.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- RFP Cast Iron Valve Boxes and Lids
- Solicitation number
- 26-0068
- Issued by
- Tarrant County, Texas
About this file
This is a pricing calculation instruction document supporting an RFP issued by the City of Fort Worth, Texas, for Cast Iron Valve Boxes and Lids for the Water Department on an as-needed basis. The document serves as a template for bidders to calculate and submit discount and markup pricing for parts and repair services associated with the procurement.
Bidders are required to provide pricing and discount percentages in the designated spreadsheet cells, with the document containing automated calculation formulas to compute markup and discount pricing in cells highlighted in purple for evaluation purposes. The completed unit price from Cell F6 must be transferred to Bid Table BT-25GQ for line items 1-13, with the specific line item shown requesting a discount percentage for parts for repairs on a $15,000.00 unit price basis. The instructions emphasize that all requested information must be completed accurately; failure to properly fill in the spreadsheet or transfer pricing to the bid table will result in the bid being deemed non-responsive. Bidders unable to provide the requested services must select "no bid" on Bid Table BT-25GQ.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 4-RFP-03-Draft Vendor Services Agreement.pdf | ||
| 2-RFP-06-Small Business Utilization Form V1.docx | DOCX document | |
| 7-RFP-07-Deviations.xlsx | XLSX spreadsheet | |
| 6-RFP-04-Authorized Signature and Questionnaire.pdf | ||
| 8-RFP-08-Reference Sheet.pdf | ||
| 1-RFP-05-Forms.pdf | ||
| 3-RFP-01-Instruction to Proposers.pdf | ||
| 5-RFP-02-Scope of Services.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Discount and Markup Calculation |
| Instructions: Bidder shall provide pricing and percentages on the line item below. By filling out the percentages below, the charts labeled in purple will begin to be filled out by using formulas (Please do not include negative numbers or negative percentages). For evaluation purposes, the charts labeled in purple is to help vendors calculate their discount and markup pricing. Please provide the the unit price amount below to Bid Table BT-25GQ. Please note that all information requested shall be filled in. If your company does not provide these services, please select no bid on Bid Table BT-25GQ. If the information on this spreadsheet is incorrectly filled in to the bid table, your bid will be deemed non-responsive. |
| Please provide the Unit Price in Cell F6 to Bid Table BT-25GQ line #1-13 | |||||
| # | Item | UOM | Quantity Required | Discount Percentage | Unit Price |
| #2-6 | Parts for Repairs, Discount Percentage | DO | $15,000.00 | $15,000.00 |
File details come from the government source that posted it. Updated .