4-RFP-08-Discount Calculator.xlsx
XLSX spreadsheet 13 KB Posted
- Solicitation number
- 26-0251
- Issued by
- Tarrant County, Texas
About this file
This is a Discount and Markup Calculation spreadsheet for a Request for Proposal issued by the City of Fort Worth, Texas, for irrigation and grounds maintenance parts and materials to be procured on an as-needed basis for the Park and Recreation and Aviation Departments. The spreadsheet establishes 26 line items across six primary categories covering plants and live materials, organic and inorganic matter in bulk and bagged formats, soil conditioners, erosion control and fencing materials, chemical products including fertilizers and pesticides, and mechanical irrigation components and accessories. Each line item is based on a standardized $10,000.00 baseline unit price, with bidders required to provide discount percentages that will automatically calculate discounted unit prices through integrated formulas.
Bidders must complete all required fields in the discount calculator and transfer the resulting unit prices to the official Bid Table BT-23HQ; failure to accurately complete and transfer pricing information may result in the bid being deemed non-responsive. The instructions explicitly prohibit the submission of negative numbers or negative percentages. Bidders unable to provide services for specific line items must indicate "no bid" on the applicable bid table entry. The spreadsheet functions as a pricing standardization tool designed to ensure consistent evaluation of vendor proposals across all product categories and enable straightforward cost comparisons among competing bidders.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 7-RFP-05-CFW Required Forms.pdf | ||
| 2-RFP-04-Authorized Signature and Questionnaire.pdf | ||
| 5-RFP-07-Deviations.xlsx | XLSX spreadsheet | |
| 3-RFP-06-Small Business Utilization Form V1.pdf | ||
| 8-RFP-01-Instruction to Proposers.pdf | ||
| 1-RFP-02-Scope of Services.pdf | ||
| 9-Reference 2026-SBE-Certification.pdf | ||
| 10-RFP 26-0251 Pre-Proposal 9.3.26.pptx | PPTX presentation | |
| 6-RFP-03-Draft Vendor Service Agreement.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 cells labeled in purple are to help vendors calculate their discount pricing. Please provide the the unit price amount below to Bid Table BT-23HQ. 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-23HQ. If the information on this spreadsheet is incorrectly filled in to the bid table, your bid may be deemed non-responsive. |
| Please provide the Unit Price Cell to fill out Bid Table BT-23HQ | |||||
| # | Item | UOM | Quantity Required | Discount Percentage | Unit Price |
| #1-1 | Plants, Live Trees | Percent | $10,000.00 | $10,000.00 | |
| #1-2 | Plants, Live Shrubs | Percent | $10,000.00 | $10,000.00 | |
| #1-3 | Plants, Ground Cover, Annuals, and Perennials | Percent | $10,000.00 | $10,000.00 | |
| #1-4 | Seed, Grass, Edible and Non-edible | Percent | $10,000.00 | $10,000.00 | |
| #2-1 | Organic Matter, BULK, Topsoil, Comport, Manure, Peat Moss, Potting Mix, Topdressing, Mulch | Percent | $10,000.00 | $10,000.00 | |
| #2-2 | Organic Matter, BAGGED, Topsoil, Comport, Manure, Peat Moss, Potting Mix, Topdressing, Mulch | Percent | $10,000.00 | $10,000.00 | |
| #2-3 | Inorganics & Minerals, BULK, Dirt, Sand, Silt, Clay, Rock, Gravel | Percent | $10,000.00 | $10,000.00 | |
| #2-4 | Inorganics & Minerals, BAGGED, Dirt, Sand, Silt, Clay, Rock, Gravel | Percent | $10,000.00 | $10,000.00 | |
| #2-5 | Soil Conditioners, BULK, Lime, Sulfur, Gypsum, Vermiculite, Pumice | Percent | $10,000.00 | $10,000.00 | |
| #2-6 | Soil Conditioners, BAGGED, Lime, Sulfur, Gypsum, Vermiculite, Pumice | Percent | $10,000.00 | $10,000.00 | |
| #3-3 | USGA Sand | Percent | $10,000.00 | $10,000.00 | |
| #4-1 | Bed Edging Materials | Percent | $10,000.00 | $10,000.00 | |
| #4-2 | Nursery Products, Tree Staking Systems, Barriers, Wraps, etc. | Percent | $10,000.00 | $10,000.00 | |
| #4-3 | Erosion Control Materials | Percent | $10,000.00 | $10,000.00 | |
| #4-4 | Fencing Materials | Percent | $10,000.00 | $10,000.00 | |
| #5-1 | Agency-priced Products | Percent | $10,000.00 | $10,000.00 | |
| #5-2 | Fertilizers | Percent | $10,000.00 | $10,000.00 | |
| #5-3 | Pesticides, Insecticides, Fungicides | Percent | $10,000.00 | $10,000.00 | |
| #5-4 | Nematicides | Percent | $10,000.00 | $10,000.00 | |
| #5-5 | Water Adjustment, Algicides | Percent | $10,000.00 | $10,000.00 | |
| #6-1 | Mechanical Irrigation, Components, Related Accessories | Percent | $10,000.00 | $10,000.00 | |
| #6-2 | Additional Parts | Percent | $10,000.00 | $10,000.00 |
File details come from the government source that posted it. Updated .