7-Attachment E - Cost Sheet Market Basket.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Second Market Foods (RR27-105)
- Solicitation number
- RR27-105
- Issued by
- Utah
About this file
This is a cost sheet and market basket attachment for a Request for Proposals issued by the State of Utah Division of Purchasing, conducted by the Utah Department of Corrections, for Second Market Food Products (RR27-105). The RFP anticipates multiple contract awards to supply second market food products to the Department of Corrections across two regions: Region 1 (Salt Lake and Utah County) and Region 2 (Sanpete County/Gunnison). The cost sheet requires offerors to provide pricing for a defined market basket of frozen foods and shelf-stable items, including battered fish, donuts, omelets, egg rolls, breaded chicken patties, meatballs, bran muffins, and various kosher and halal meals. All prices must include shipping and delivery on an FOB Destination basis for both regions.
Offerors must complete the cost sheet by providing their company name, lead times for stock and special order items, pricing per case using the lowest case count minimum, product origin information (United States produced), dietary certifications (Kosher/Gluten Free), and case count minimums with additional information regarding product specifications and mix-and-match options. The cost sheet includes separate sections for Region 1 and Region 2 with market basket totals calculated for each region, and a final combined total cost for both regions that will be used in cost evaluation. Offerors must also provide pricing structures for unlisted, spot-market, or secondary items, specifying whether they use cost-plus or discount-off list pricing with corresponding markup or discount percentages and benchmark references. Disqualification may result from deviations from the cost sheet format or incomplete submission of required yellow-highlighted fields.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-Claim of Business Confidentiality Updated.pdf.pdf | ||
| 8-Attachment D - Technical Criteria.docx | DOCX document | |
| 6-Interactive-Score-Sheet Informational Purpose Only.xls | XLS spreadsheet | |
| 2-Vendor Prerequisites - RFP Agency.pdf | ||
| 5-Attachment C - Scope of Work.docx | DOCX document | |
| 4-Attachment B - UDC Terms and Conditions - Rev. September 2021.docx | DOCX document | |
| 3-Attachment A - Standard Terms and Conditions.docx | DOCX document |
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 E - COST SHEET/MARKET BASKET LIST
Second Market Foods
RR27-105
| 1 | Offeror must use this Attachment D - Cost sheet to show cost, any deviation from this sheet may be cause for disqualification. |
| 2 | Price must include shipping and delivery for both Region 1 and Region 2 (FOB Destination). Offeror's Brand, |
| 3 | Offerors must fill out all Yellow boxes /columns - Offeror name, Lead time (Stock items), Lead time (Special Order items), and columns G, I, J, K, and Discount Mark Up info at the bottom of the sheet. |
| 4 | In column (G) - Provide Offeror's Price per Case (Using the lowest case count minimum only) |
| 5 | In column (H) - DO NOT EDIT -- Table will calculate Offeror's price PER State Provided Unit of Measure |
| 6 | In column (I) - Use the drop down list to select if the item was Produced in the United States |
| 7 | In column (J) - Use the drop down list to select if the item is Kosher, Gluten Free, Both, or none. |
| 8 | In column (K) - Provide the case count minimum for the item used (F, G) & add any extra Information (see Example, row 23) |
| 9 | Products offered must be for the Unit of Measure (UOM) indicated on the Cost sheet. LB=Pounds, OZ=Ounces, CT=Count, DZ=Dozen. |
| Offeror Name: |
| Lead Time (Stock Items): |
| Lead Time (Special Order Item): |
| Region 1 - Salt Lake & Utah County | |||||
| State Provided Product | State Provided Brand | State Provided Unit of Measure | Offeror's Brand | (1) Offeror's Packaging/Size Per Case | Offeror's Price per Case |
(Using the lowest case count minimum only) Offeror's Price PER State Provided unit of measure Produced in the United States?
(Use Drop Down List) Kosher or Gluten Free?
(Use Drop Down List) Provide Case Count Minimum Used & Extra Information
(mix & match, types/flavors, etc)
| Example -Fully Cooked Meatballs (Beef/Chicken | None Specified | LB | ACME Corp | 40 | $1.95 | $ 0.05 | Yes | Kosher | $1.95 lb - 40 case min used $1.87 lb - 80 case min $1.83 lb 160 case min Mix & Match with Breakfast Patty to make make minimums. Pork Free, Trans Fat Free |
| **The line above is for example purposes only** | |||||||||
| FROZEN FOODS | |||||||||
| State Provided Brand | State Provided Unit of Measure | Offeror's Brand | (1) Offeror's Packaging/Size Per Case | Offeror's Price per Case |
(Using the lowest case count minimum only) Offeror's Price PER State Provided unit of measure Produced in the United States?
(Use Drop Down List) Kosher or Gluten Free?
(Use Drop Down List) Provide Case Count Minimum Used & Extra Information
(mix & match, types/flavors, etc)
| 1 | Battered Fish portion/sticks 3 oz | None Specified | OZ | null | |||
| 2 | DONUTS -OLD FASHIONED GLAZED CINNAMON & SUGAR CAKE 1.25 OZ, BULK | None Specified | OZ | null | |||
| 3 | DONUTS - OLD FASHIONED POWDERED SUGAR, 1.25 OZ, BULK | None Specified | OZ | null | |||
| 4 | DONUTS - OLD FASHIONED GLAZED CAKE, 1.25 OZ, BULK | None Specified | OZ | null | |||
| 5 | Plain Omelet 4 oz | None Specified | OZ | null | |||
| 6 | VEGETABLE EGG ROLLS | None Specified | LB | null | |||
| 7 | Breaded Chicken Patties, fully cooked 4 0z | None Specified | LB | null | |||
| 8 | MEATBALLS (CHICKEN/BEEF) FULLY COOKED | None Specified | LB | null | |||
| SHELF STABLE | |||||||
| State Provided Brand | State Provided Unit of Measure | Offeror's Brand | (1) Offeror's Packaging/Size Per Case | Offeror's Price per Case |
(Using the lowest case count minimum only) Offeror's Price PER State Provided unit of measure Produced in the United States?
(Use Drop Down List) Kosher or Gluten Free?
(Use Drop Down List) Provide Case Count Minimum Used & Extra Information
(mix & match, types/flavors, etc)
| 1 | Bran Muffins 2oz | None Specified | OZ | null |
| 2 | MEAL - CHEESE TORTELLINI (KOSHER) | None Specified | OZ | null |
| 3 | MEAL- PASTA w/ GARDEN VEGETABLES (KOSHER) | None Specified | OZ | null |
| 4 | MEAL - VEGETARIAN STEW (KOSHER) | None Specified | OZ | null |
| 5 | MEAL - BEEF STEW (HALAL) | None Specified | OZ | null |
| 5 | MEAL - BEEF STEW (HALAL) | None Specified | OZ | null |
| Region 1 - Market Basket Total Cost: | $0.00 |
| REGION 2- Sanpete County (Gunnison) | |||||
| FROZEN FOODS | |||||
| State Provided Brand | State Provided Unit of Measure | Offeror's Brand | (1) Offeror's Packaging/Size Per Case | Offeror's Price per Case |
(Using the lowest case count minimum only) Offeror's Price PER State Provided unit of measure Produced in the United States?
(Use Drop Down List) Kosher or Gluten Free?
(Use Drop Down List) Provide Case Count Minimum Used & Extra Information
(mix & match, types/flavors, etc)
| 1 | Battered Fish portion/sticks 3 oz | None Specified | OZ | null | ||||
| 2 | DONUTS -OLD FASHIONED GLAZED CINNAMON & SUGAR CAKE 1.25 OZ, BULK | None Specified | OZ | null | ||||
| 3 | DONUTS - OLD FASHIONED POWDERED SUGAR, 1.25 OZ, BULK | None Specified | OZ | null | ||||
| 4 | DONUTS - OLD FASHIONED GLAZED CAKE, 1.25 OZ, BULK | None Specified | OZ | null | ||||
| 5 | Plain Omelet 4 oz | None Specified | OZ | null | ||||
| 6 | VEGETABLE EGG ROLLS | None Specified | LB | null | ||||
| 7 | Breaded Chicken Patties, fully cooked 4 0z | None Specified | LB | null | ||||
| 8 | MEATBALLS (CHICKEN/BEEF) FULLY COOKED | None Specified | LB | null | ||||
| SHELF STABLE | ||||||||
| State Provided Brand | State Provided Unit of Measure | Offeror's Brand | (1) Offeror's Packaging/Size Per Case | Offeror's Price per Case | ||||
| (Using the lowest case count minimum only) | Offeror's Price PER State Provided unit of measure | Produced in the United States? | ||||||
| (Use Drop Down List) | Kosher or Gluten Free? |
(Use Drop Down List) Provide Case Count Minimum Used & Extra Information
(mix & match, types/flavors, etc)
| 1 | Bran Muffins 2oz | None Specified | OZ | null |
| 2 | MEAL - CHEESE TORTELLINI (KOSHER) | None Specified | OZ | null |
| 3 | MEAL- PASTA w/ GARDEN VEGETABLES (KOSHER) | None Specified | OZ | null |
| 4 | MEAL - VEGETARIAN STEW (KOSHER) | None Specified | OZ | null |
| 5 | MEAL - BEEF STEW (HALAL) | None Specified | OZ | null |
| Region 2 - Market Basket Total Cost: | $0.00 |
| Total Region 1 & Region 2 Pricing | $0.00 |
| *This total will be used for cost evaluation |
Please state your pricing structure for unlisted, spot-market, or secondary items not covered in the itemized bidding sheet.
If a category uses Cost-Plus pricing, provide your Maximum Markup Percentage over net landed cost.
If a category uses List/Index pricing, provide your Minimum Guaranteed Discount Percentage off catalog/index (Note: This section will not be scored during the RFP cost evaluation, but may be part of future contracts, if awarded)
# Food Category / Item Type Pricing Basis (Select One in Drop down) Cost Plus or
| Discount Off | Maximum Markup % (Over Landed Cost) Input % |
| If applicable | Minimum Discount % (Off List / Benchmark Index) |
Input %
| If appliable | Benchmark Reference Used (e.g., USDA, Sysco List, Invoice) | |
| 1 | Dry Grocery (Close-Dated Overstock | |
| 2 | Frozen Foods (Salvage/Overrun) | |
| 3 | Refigerated/Fresh (Short-dated) | |
| 4 | Bulk/Specialty Spot Lots |
File details come from the government source that posted it. Updated .