Attachment B Price Submission Form Ranking Used to Determine the Award of the Bid.xlsx
XLSX spreadsheet 13 KB Posted
- Contract number
- 26-586SBE-CHFED-P-95008
- Issued by
- Illinois
About this file
I appreciate your request, but I'm unable to access the actual contents of the file "Attachment B Price Submission Form Ranking Used to Determine the Award of the Bid.xlsx" that you've referenced. While you've provided the GovTribe ID and filename, the document itself has not been included in a format I can read.
To provide the comprehensive summary you've requested, I would need you to either:
- Share the file contents directly in your message
- Paste the relevant text or data from the spreadsheet
- Provide a screenshot or transcription of the document
Once you provide the actual document content, I'll be able to deliver a professional two-paragraph summary identifying the parties involved and the key contract terms without any introductory preamble.
View the file
Other files
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
| Price Submission Form & Selection Process for the Award of the Contract | |||||
| All complete bids that are responsive and responsible will be placed on an Excel document with the following information: Name of Bidder, Price Per Pound, Total Amount of Pounds, & Total Price of Bid for each bidder. Then each bid will be ranked by lowest price per pound to highest price per pound. The awarding agency will then start at the top of the list (lowest price per pound) and award down the list until the Total Price of the Bids reaches or is close to the total amount of this contract. A vendor or multiple vendors may receive a full award, a vendor may receive a partial award, and a vendor or multiple vendors may not receive an award. Please see example below. | |||||
| Price Per Pound (ranked lowest to highest) | Total Number of Pounds Bidder Can Provide | Total Price of the Bid (price per pound X total number of pounds bidder can provide) | Name of Bidder | Running total price of contract: | Award Status |
| $6.52 | 10,000 | $65,200.00 | ABC Farms | ||
| $7.17 | 75,000 | $537,750.00 | DEF Distributing | $602,950.00 | full award |
| $7.51 | 8,000 | $60,080.00 | GHI LLC | $663,030.00 | full award |
| $8.88 | 100,000 | $888,000.00 | JKL Family Farm | $1,551,030.00 | full award |
| $9.36 | 12,000 | $112,320.00 | MNO Processing | $1,663,350.00 | full award |
| $10.04 | 150,000 | $1,506,000.00 | PQR Coop | $3,169,350.00 | partial award |
| $12.68 | 150,000 | $1,902,000.00 | STU Distributors Inc. | $5,071,350.00 | non-award |
| $15.85 | 25,000 | $396,250.00 | VWX Processers | $5,467,600.00 | non-award |
| The total price of the contract is set to not exceed $3 million, which is indicated by the red line. Based on the maximum amount of the contract and ranking the bidders by the lowest per pound price, this contract could be awarded to ABC Farms, DEF Distributing, GHI LLC, JKL Family Farm, MNO Processing, & PQR Coop. | ||
| Vendor PQR Coop could be awarded a partial award because the full award would go over the maximum for the total contract. Therefore, this vendor would get a partial award to bring the running total under $3 million. For example, they may get an award for 100,000 pounds instead of the full 150,000 pounds they bid. | ||
| REQUIRED - Submit your Price Quote and Total Number of Pounds You Can Provide Below | ||
| This form MUST be submitted with your Bid! | ||
| All bidders must complete the information below & submit it with your bid packet in order to be considered. | ||
| Price Per Pound | Total Number of Pounds You Can Provide | Name of Bidder |
| REQUIRED - Please provide estimated delivery dates below along with an estimate of the number of pounds per proposed delivery. The estimated pounds for each delivery date below must match the total pounds you provided above (e.g., total pounds above is 1,000 pounds – estimated deliveries are 500 pounds May 1 and 500 pounds June 1). Delivery dates are estimates, and final delivery dates and times must be made with the warehouse staff. All deliveries must be made no later than June 15, 2026. | |
| This form MUST be submitted with your Bid! | |
| Estimated Delivery Date | Estimated pounds delivered to Granite City Warehouse |
File details come from the government source that posted it. Updated .