9-26027AIT Beverages for Student Meals - Attachment Table A (BT-78TY).xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- Beverages for Student Meals
- Solicitation number
- 26027AIT
- Issued by
- Clark County, Nevada
About this file
This is a bidding attachment table for a Nevada school district's Beverages for Student Meals procurement, establishing supplier authorization for beverage purchases across the district's breakfast and lunch programs. The solicitation is organized into three lots: Lot 1 contains juice box products with specifications for assorted flavors in 100% juice, no sugar added formulations with aseptic shelf-stable packaging requiring minimum six-month shelf life at receipt, with estimated annual servings ranging from 640,000 to 4,600,000 units depending on the specific item; Lot 2 addresses bottled purified drinking water in 16.9-ounce bottles with 24 per case and 350,000 estimated annual servings; and Lot 3 covers dairy-free milk alternatives in vanilla and chocolate flavors for special diets, each with 25,000 estimated annual servings. All items require USDA compliance, and juice products must meet specific calorie, sodium, and nutrition content requirements. The document functions as a response template where bidders indicate their bid or no-bid decision for each item and, if bidding, must complete all required data fields including manufacturer information, product numbers, shelf life in days, lead time in days, servings per case, and pricing structures for both full truckload (FTL) and less than truckload (LTL) scenarios.
Bidders must submit responses using text-based formatting without special characters or Excel formulas, maintaining the exact worksheet structure provided. The pricing submission requires per-serving costs, case quantities, and per-case costs for both FTL and LTL delivery options, with the system calculating estimated spend totals. Bidders may submit multiple responses for individual items through the Additional Responses worksheet by referencing the item number from the Primary Responses sheet. All editable cells for any item must contain valid values if bidding or remain blank if selecting no-bid; failure to comply with these formatting and completion requirements will invalidate submissions. Technical support for submission issues is available through Euna Procurement.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 6-Food Sv RFP T Cs Pur-RFP-002 8-18-25.doc | DOC document | |
| 3-Public Disclosure Form 2-17-26.docx | DOCX document | |
| 7-26027AIT Beverages for Student Meals - Proposal.docx | DOCX document | |
| 2-Form W-9 (Rev.pdf | ||
| 5-Supplier Contact List Designation Form 09-2022.pdf | ||
| 4-Updated Supplier Federal 2CFR200 Certification Form 10.20.23.pdf | ||
| 1-Supplier Application Update Form 4-2025.docx | DOCX document | |
| 8-26027AIT Beverages for Student Meals BOL Attachment B (BT-78QY).xlsx | XLSX spreadsheet |
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
Instructions
| 26027AIT Beverages for Student Meals - Attachment Table A (BT-78TY) |
| Instructions |
| - When pasting content, please use Paste Special as Text without any formatting. |
- You can only submit text based responses, please do not use special characters like emojis.
- Please do not change the structure of any of the worksheets. Changing the structure will invalidate your submission.
- Any additional information outside of the given structure of the worksheets will not be visible to the purchaser.
- Please do not save this file in a different format. Saving this file in a different format will invalidate your submission.
- Please follow the instructions provided along with this file to submit it back to Euna Procurement.
- By default, every item has `No Bid` selected for the `Bid/No Bid Decision` column.
- If you decide to bid on an item, then you must select `Bid` in the `Bid/No Bid Decision` column and all of the other editable cells for the item must contain a valid value.
- If you decide not to bid on an item, then you must select `No Bid` in the `Bid/No Bid Decision` column and all of the other editable cells for the item must be blank.
- To submit additional bids for an item, you must go to the Additional Responses tab.
- If you decide to submit an additional response for an item, then you must also complete a primary response bid for that item.
- Every item has a unique item number found in column D. To submit an additional bid for an item, enter the item number from the Primary Responses sheet into the blank item number cell on the Additional Responses sheet (column D).
- Entering the item number on the Additional responses sheet will cause the line to populate with item-specific info. An additional response can now be completed by filling in the blank cells with the bid information you wish to submit.
- You can submit as many additional bids for each item as you would like
- Please do not use Excel formulas in your responses.
- If you have any questions regarding the content of this file, please contact the appropriate purchaser.
- If you have any technical problems, please contact Euna Procurement at support.bonfire@eunasolutions.com.
08917accf496d41b0d825b7347d91e8e3f760cb71fa3d1f5572e17117073fd8b36779a41662390139ee6a420ee7990d5b6f8e89c9eb6cc2b267439321e7aa6bd5ppeQGcQwFghcTzph5M4JWqry6aDnjYI7xfDRYp4D5DzcZhF6HUPJzT9HamDrs6b
Primary Responses
| Primary Responses | |||||||||||||||||||
| Success: All data is valid! | |||||||||||||||||||
| Text | Text | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Text | ||||||||
| Status | Bid/No Bid Decision | # | Description | Estimated Annual Serving | Manufacturer | Product Number | Shelf Life (In Days) | Lead Time (In Days) | Servings per Case | FTL Cost per Serving | FTL Quantity in Cases | FTL Cost per Case | LTL Cost per Serving | LTL Quantity in Cases | LTL Cost per Case | Flavor | FTL Estimated Spend | LTL Estimated Annual Spend | |
| Helper:ResponseStatus | BidTableItem:BidTableItemID | BidTableItemResponse:IsBidding | Helper:BidTableBasketOrderWithItemOrder | BidTableItem:ItemName | BidTableItem:380983 | BidTableItemResponse:328447 | BidTableItemResponse:328449 | BidTableItemResponse:328451 | BidTableItemResponse:328452 | BidTableItemResponse:328453 | BidTableItemResponse:328454 | BidTableItemResponse:328456 | BidTableItemResponse:328457 | BidTableItemResponse:328458 | BidTableItemResponse:328459 | BidTableItemResponse:328460 | BidTableItemResponse:328493 | BidTableFormula:164012 | BidTableFormula:164005 |
| Lot 1 Juice | |||||||||||||||||||
| Not Bidding | 3775173 | No Bid | #1-1 |
Juice Box, Assorted Flavors, Vegetable, 100% Juice, No Sugar Added, Aseptic Shelf-Stable Packaging for a Minimum 6 Months at time of receipt, Straw Attached. Calories Maximum 100, Saturated fat (grams) Not to exceed 0, Sodium (mg) Not Exceed 70, Meets CN equivalent of Veg. (cups) 3/4 cup, Veg. Subgroup Red/Orange
| 640000 | - | - | ||||
| Not Bidding | 3775174 | No Bid | #1-2 |
Juice Box, Assorted Flavors, Vegetable, 100% Juice, No Sugar Added, Aseptic Shelf-Stable Packaging for a Minimum 6 Months at time of receipt, Straw Attached. Calories Maximum 100, Saturated fat (grams) Not to exceed 0, Sodium (mg) Not to exceed 70mg, Meets CN equivalent of Veg (cups) 3/4 cup, Veg Subgroup Additional/Other
| 640000 | - | - | ||||
| Not Bidding | 3775175 | No Bid | #1-3 |
Juice Box, Assorted Flavors, 100% Juice, No Sugar Added, Aseptic Shelf-Stable Packaging for a Minimum 6 Months at time of receipt, Straw Attached. Calories Maximum 100, Saturated fat (grams) Not to exceed 0, Sodium (mg) Not to exceed 30, Meets CN equivalent of Fruit (cups) 1/2 cup
| 4600000 | - | - | ||||
| Not Bidding | 3775176 | No Bid | #1-4 |
Juice Box, Assorted Flavors, 100% Juice, No Sugar Added, Aseptic Shelf-Stable Packaging for a Minimum 6 Months at time of receipt, Straw Attached. Calories Maximum 100, Saturated fat (grams) Not to exceed 0, Sodium (mg) Not to exceed 30, Meets CN equivalent of Fruit (cups) 1/2 cup
| 4600000 | - | - | ||||
| Not Bidding | 3775177 | No Bid | #1-5 |
Juice Box, Assorted Flavors, 100% Juice, No Sugar Added, Aseptic Shelf-Stable Packaging for a Minimum 6 Months at time of receipt, Straw Attached. Calories Maximum 100, Saturated fat (grams) Not to exceed 0, Sodium (mg) Not to exceed 30, Meets CN equivalent of Fruit (cups) 1/2 cup
| 4600000 | - | - | ||||||
| Basket Total | 0 | [$$ ]0.00 | ||||||
| Lot 2 Water | ||||||||
| Not Bidding | 3775178 | No Bid | #2-1 |
Bottled Purified Drinking Water, Minimum Shelf Life 12 months at time of receipt, 16.9oz per bottle, 24 per case.
| 350000 | - | - | ||||||
| Basket Total | 0 | [$$ ]0.00 | ||||||
| Lot 3 Milk Alternative -Special Diets Only | ||||||||
| Not Bidding | 3775179 | No Bid | #3-1 |
Milk, Dairy Free Alternative, Vanilla, 8oz, K12 USDA Compliant, Aseptic Shelf-Stable Packaging. Soy Free, Nut Free, 100% Vegan, Gluten Free, Lactose Free, Egg Free.
| 25000 | - | - | ||||
| Not Bidding | 3775180 | No Bid | #3-2 |
Milk, Dairy Free Alternative, Chocolate, 8oz, K12 USDA Compliant, Aseptic Shelf-Stable Packaging. Soy Free, Nut Free, 100% Vegan, Gluten Free, Lactose Free, Egg Free.
| 25000 | - | - | |||
| Basket Total | 0 | [$$ ]0.00 | |||
| Grand Total | 0 | [$$ ]0.00 |
Additional Responses
| Additional Responses | |||||||||||||||||||
| Success: All data is valid! | |||||||||||||||||||
| Text | Text | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Numeric | Text | ||||||||
| Status | Bid/No Bid Decision | # | Description | Estimated Annual Serving | Manufacturer | Product Number | Shelf Life (In Days) | Lead Time (In Days) | Servings per Case | FTL Cost per Serving | FTL Quantity in Cases | FTL Cost per Case | LTL Cost per Serving | LTL Quantity in Cases | LTL Cost per Case | Flavor | FTL Estimated Spend | LTL Estimated Annual Spend | |
| Helper:ResponseStatus | BidTableItem:BidTableItemID | BidTableItemResponse:IsBidding | Helper:BidTableBasketOrderWithItemOrder | BidTableItem:ItemName | BidTableItem:380983 | BidTableItemResponse:328447 | BidTableItemResponse:328449 | BidTableItemResponse:328451 | BidTableItemResponse:328452 | BidTableItemResponse:328453 | BidTableItemResponse:328454 | BidTableItemResponse:328456 | BidTableItemResponse:328457 | BidTableItemResponse:328458 | BidTableItemResponse:328459 | BidTableItemResponse:328460 | BidTableItemResponse:328493 | BidTableFormula:164012 | BidTableFormula:164005 |
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - | |||||||||||||||
| - | N/A | N/A | - | - |
image1.png
File details come from the government source that posted it. Updated .