Attachment A - Cost Sheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Brand Name Pop Products for NDCS Facilities
- Solicitation number
- 123131 OR
- Issued by
- Douglas County, Nebraska
About this file
This is a Cost Sheet (Attachment A) for a "Brand Name" Pop contract issued by the Nebraska Department of Administrative Services (DAS), Materiel Division, State Purchasing Bureau (SPB) for the Nebraska Department of Correctional Services (NDCS). The solicitation covers the procurement of soft drinks and vending machine services for six correctional facilities, including Nebraska State Penitentiary, Reception & Treatment Center, Omaha Correctional Center, Nebraska Correctional Youth Facility, Nebraska Correctional Center for Women, and Tecumseh State Correctional Institute. The contract requires vendors to provide and maintain token-operated vending machines, with an estimated annual usage ranging from 400 to 8,500 product cases per facility. The initial contract term is two years, with options to renew for two additional two-year periods, and the bid opening is scheduled for September 26, 2025, at 2:00 PM Central Time.
The pricing structure includes a comprehensive core list of 40 specific soda types and a catalog of additional beverages, with pricing based on 24 twelve-ounce aluminum can cases. Vendors must submit fixed prices for the core list and percentage discounts for the catalog/non-core list, providing catalogs that show regular retail prices, proposed discounts, and final discounted prices. The vendor will be responsible for owning, operating, and maintaining the vending machines at no additional cost to the state, with machines required to accept specific tokens and potentially accommodate smart card technology. While no incumbent vendors are identified and no specific set-aside designations are mentioned, the state reserves the right to add or remove items from the core list and may contract with multiple vendors or terminate the contract based on funding availability.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 123131 OR Response - LinPepCo Partnership.pdf | ||
| 123131 OR List of Respondents.docx | DOCX document | |
| 123131 OR Response - Canteen Vending.pdf | ||
| 123131 OR Response - Company Kitchen.pdf | ||
| 123131 OR Response - Keurig Dr. Pepper.pdf | ||
| Attachment A - Cost Sheet.xlsx | XLSX spreadsheet | |
| 123131 OR Awarded Bid Tab.xlsx | XLSX spreadsheet | |
| 123131 OR Brand Name Pop.docx | DOCX document | |
| 123131 OR Bid Tab.xlsx | XLSX spreadsheet | |
| 123131 OR Intent to Award.docx | DOCX document | |
| 123131 OR Response - Chestman Coca-Cola.pdf | ||
| Attachment B - Delivery Addresses, Contacts, Instructions.pdf | ||
| Solicitation Addendum One - Q&A.docx | DOCX document | |
| Solicitation Addendum One - Q&A.docx | DOCX document | |
| 123131 OR Brand Name Pop.docx | DOCX document | |
| Attachment B - Delivery Addresses, Contacts, Instructions.pdf | ||
| Attachment B - Delivery Addresses, Contacts, Instructions.pdf | ||
| Attachment A - Cost Sheet.xlsx | XLSX spreadsheet | |
| 123131 OR Brand Name Pop.docx | DOCX document |
Show all 19
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
ATTACHMENT "A"
123131 OR COST SHEET
"BRAND NAME" POP
VENDOR NAME: _____________________________________
| DATE: ____________________ | |
| LOCATIONS | |
| NDCS LOCATIONS FOR BID INCLUDE NSP, RTC, OCC, NCYF, NCCW, & TSCI. |
PLEASE INITIAL THE "YES" FIELD FOR EACH LOCATION BEING BID AND INITIAL THE "NO" FIELD FOR EACH LOCATION NOT BEING BID USING LINES #1-6 BELOW
LINE # NDCS LOCATION
# OF MACHINES NEEDED | ESTIMATED ORDER QUANTITY
| YES | ||
| BIDDER WILL SERVICE THIS LOCATION | NO |
BIDDER WILL NOT SERVICE THIS LOCATION
1 NEBRASKA STATE PENITENTIARY (NSP) LINCOLN NE
13 TOKEN MACHINES | ESTIMATED 2,100 CASES
2 RECEPTION & TREATMENT CENTER (RTC) LINCOLN NE
14 TOKEN MACHINES | ESTIMATED 2,200 CASES
3 OMAHA CORRECTIONAL CENTER (OCC) OMAHA NE
9 TOKEN MACHINES | ESTIMATED 8,500 CASES
4 NEBRASKA CORRECTIONAL YOUTH FACILITY (NCYF) OMAHA NE
3 TOKEN MACHINES | ESTIMATED 400 CASES
5 NEBRASKA CORRECTIONAL CENTER FOR WOMEN (NCCW) YORK NE
7 Token MACHINES | ESTIMATED 5,300 CASES
6 TECUMSEH STATE CORRECTIONAL INSTITUTE (TSCI) TECUMSEH NE
13 TOKEN MACHINES | ESTIMATED 6,000 CASES
| CORE LIST |
| PREFERRED "BRAND NAME" POP NAMES ARE LISTED FOR EACH LINE IN THE "BRAND NAME" POP DESCRIPTIONS COLUMN. |
VENDOR SHOULD LIST THE BRAND NAME OF POP BEING BID FOR EACH LINE WITHIN THE BRAND NAME(S) BIDDING COLUMN.
PRICES BID SHALL REPRESENT THE PRICE PER CASE. PLEASE FILL A PRICE IN THE BID PRICE PER CASE COLUMN. A CASE IS DEFINED AS BEING COMPRISED OF TWENTY-FOUR (24) TWELVE (12) OUNCE ALUMINUM CANS
| LINE # | "BRAND NAME" POP DESCRIPTIONS | BRAND NAME(S) BIDDING | BID PRICE PER CASE |
| 7 | Pepsi, Coke, RC Cola; Regular |
tc={DCFA84EE-C5C6-4DFF-95BB-0A91BF6893BE}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Not usefull to use the same estimated quantity for each type of pop, because this number is also meant to inform the bidder on expected order quantity. I don’t know that we can do an extended/total price evaluation on this.
Reply:
| The best information we could provide prospective bidders is maybe a 2024 order total for each soda type (if available). Otherwise, I think we stick to just letting vendors know what the estimated case order usage is for each location. | 8 | Diet Pepsi, Diet Coke, Diet RC Cola |
| 9 | Wild Cherry Pepsi, Cherry Coke, RC Cherry Cola; Regular | |
| 10 | Diet Wild Cherry Pepsi, Diet Cherry Coke | |
| 11 | Mountain Dew, Mellow Yellow; Regular | |
| 12 | Diet Mountain Dew, Diet Mellow Yellow | |
| 13 | Mountain Dew Code Red | |
| 14 | Barq's Root Beer, Mug Root Beer, A & W Root Beer, Mug Cream Soda; Regular | |
| 15 | Diet Barq's Root Beer, Diet Mug Root Beer, Diet A & W Root Beer, Diet Mug Cream Soda | |
| 16 | Mug Cream Soda, A&W Cream Soda; Regular | |
| 17 | Diet Mug Cream Soda, A&W Cream Soda Zero Sugar | |
| 18 | Sunkist Strawberry, Fanta Strawberry, Crush Strawberry | |
| 19 | Sunkist Grape, Fanta Grape, Crush Grape | |
| 20 | Sunkist Lemonade | |
| 21 | Sunkist Orange, Fanta Orange, Crush Orange | |
| 22 | Sunny Delight Orange | |
| 23 | 7 UP; Regular | |
| 24 | Diet 7 UP | |
| 25 | Cherry 7UP; Regular | |
| 26 | Diet Cherry 7 UP | |
| 27 | Ruby Red Squirt | |
| 28 | Squirt Citrus, Sundrop Citrus Soda; Regular | |
| 29 | Diet Citrus Squirt, Diet Sundrop Citrus Soda | |
| 30 | Dr Pepper; Regular | |
| 31 | Diet Dr Pepper | |
| 32 | Cherry Dr Pepper; Regular | |
| 33 | Diet (Zero Sugar) Cherry Dr Pepper | |
| 34 | Big Red Soda | |
| 35 | Hawaiian Punch | |
| 36 | Canada Dry Ginger Ale, Seagrams Ginger Ale, Schweppes Ginger Ale | |
| 37 | Canada Dry Zero Sugar Ginger Ale, Seagrams Diet Ginger Ale, Schweppes Diet Ginger Ale. | |
| 38 | Starry (formerly Sierra Mist), Sprite | |
| 39 | Diet Starry (formely Diet Sierra Mist), Diet Sprite | |
| 40 | Brisk Iced Tea, | |
| 41 | Klarbrunn Sparkling Water | |
| CATALOG/NON-CORE | ||
| THE FOUR CATEGORIES LISTED BELOW WILL MAKE UP THE CATALOGUE/NON-CORE LIST. PLEASE BID A PERCENTAGE DISCOUNT FOR EACH OF THE FOUR CATALOG/NON-CORE CATEGORIES LISTED BELOW. |
CATALOG(S) AND/OR PRICE LIST(S) FOR ALL “CATALOG/NON-CORE BRAND NAME POP” SHOULD BE SUBMITTED WITH THE PROPOSAL AND MUST SHOW THE REGULAR RETAIL PRICE OF THE PRODUCT, THE PERCENTAGE OF DISCOUNT AS PROPOSED, AND THE FINAL DISCOUNTED PRICE OF ALL “CATALOG/NON-CORE ITEM DESCRIPTION”.
BIDDER MAY SUBMIT A FINAL PRICE LIST FOR ALL BEVERAGES THAT DO NOT FALL UNDER THE CORE LIST.
| LINE # | CATALOG/NON-CORE LIST CATEGORIES | |
| DISCOUNT | ||
| UOM | DISCOUNT PERCENTAGE | |
| 42 | OTHER BEVERAGES OR FLAVORS OF CANNED POP |
CATALOG/NON-CORE Percentage Discount
Not usefull to use the same estimated quantity for each type of pop, because this number is also meant to inform the bidder on expected order quantity. I don’t know that we can do an extended/total price evaluation on this.
The best information we could provide prospective bidders is maybe a 2024 order total for each soda type (if available). Otherwise, I think we stick to just letting vendors know what the estimated case order usage is for each location.
File details come from the government source that posted it. Updated .