Appendix B - Cost Matrix FFP Products-(10-25-17) revised.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Friends and Family Package Program
- Solicitation number
- 6100043850
- Issued by
- Mount Aetna CDP, Pennsylvania
About this file
This document is an Appendix B - Cost Matrix for a contract opportunity issued by the Pennsylvania Department of Corrections (PADOC). The matrix contains instructions and a detailed list of various food and snack items such as soups, beverages, breakfast foods, cakes/pies/pastries, prepared/preserved foods, cheese, sauces/spreads/condiments, nuts/dried fruits, crackers, sweet biscuits/cookies, snack foods, and candies. The list includes product descriptions, alternative/comparable items, estimated quantities, unit prices, and category size limitations. Bidders are required to complete the shaded areas with their bid pricing and return the completed matrix as part of their proposal. The total cost per ounce and quantity is worth 70% of the total score, while the minimum 20% commission refunded to PADOC is worth 30% of the total score.
The Cost Matrix provides detailed specifications and requirements for the various product categories, allowing vendors to submit competitive pricing for the PADOC contract opportunity. Bidders must adhere to the category size limitations and provide pricing that meets or exceeds the minimum 20% commission refund to PADOC. This structured approach enables PADOC to evaluate proposals objectively based on both pricing and commission terms.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Addendum 6 - 6100043850.pdf | ||
| Addendum 1 - 6100043850 (10-12-17).pdf | ||
| Addendum 5 - 6100043850 (11-13-17).pdf | ||
| Addendum 3 - 6100043850 (10-25-17).pdf | ||
| Addendum 4 - 6100043850 (11-3-17).pdf | ||
| Appendix B - Cost Matrix FFP Products-(10-2-17).xlsx | XLSX spreadsheet | |
| PA Family Package Sales History.xlsx | XLSX spreadsheet | |
| Product Listing (10-12-17).xlsx | XLSX spreadsheet | |
| GSPUR-89 Reciprocal Limitations Act Reqirements.doc | DOC document | |
| 6100043850 - Friends and Family Package Program (10-2-17).pdf | ||
| Addendum 2 - 6100043850.pdf | ||
| Product Listing - Revised (10-13-17).xlsx | XLSX spreadsheet |
Show all 12
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
| (Revised) Appendix B - Cost Matrix Instructions |
| Instructions: |
| Column C - Enter the bid item that you are submitting. This item must match either the requested item in Column A or the approved Alternate Item described in Column B. If there is no Alternative Item provided in Column B then bidders must match the exact product description listed in Column A. |
| Column E - Input the per unit price of each item. |
| Column F - Input the total ounce size of the item being bid. Cannot exceed the Category Size Limitation provided. |
| Column J - (line 56) - Enter the Total Commission Refunded to PADOC (20% minimum) |
Cost Matrix - Revised (Revised) Appendix B - Cost Matrix ALL SHADED AREAS MUST BE COMPLETED
| Quantities are esitmated amounts. | |||||||||||
| Description | Alternative/Comparable Item | Bid Item | Quantity | Unit Price | Category Size Limitation | ||||||
| Enter the Number of Ounces per Item | UOM | Total Price | Cost per Ounce | Cost per Ounce x Quantity | |||||||
| Category: SOUPS | Category: SOUPS | Category: SOUPS | 3 oz | ||||||||
| Maruchan Roast Chicken Flavor Ramen 3 oz | NISSIN CHICKEN RAMEN 3 OZ | 184 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Maruchan Roast Beef Flavor Ramen 3 oz | NISSIN BEEF RAMEN 3 OZ | 128 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: BEVERAGES | Category: BEVERAGES | Category: BEVERAGES | 16 oz | ||||||||
| Maxwell House Dark Roast Espresso 4 oz | BOSTON'S BEST PREMIUM COFFEE 8 OZ or Folgers Traditional Roast 8 oz. | 1185 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Hawaiian Punch Singles To Go Fruit Juicy Red (8 pk) .74 oz | HAWAIIAN PUNCH SUGAR FREE JUICY RED SINGLES TO GO (8 CT) .75 OZ | 757 | $0.00 | 0 | BX | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Hawaiian Punch Singles To Go SF Berry Blue Typoon (8 pk) .95oz | WYLER'S LIGHT W/CAFFEINE TOTALLY TROPICAL SINGLES TO GO 6CT .70 OZ | 721 | $0.00 | 0 | BX | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: BREAKFAST FOODS | Category: BREAKFAST FOODS | Category: BREAKFAST FOODS | 20 oz | ||||||||
| Quaker Maple Brown Sugar Granola Bar 1.26oz | FLAVOR KIST CRUNCHY OATS N HONEY GRANOLA BAR SINGLE 1.5 OZ | 483 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Quaker Maple Brown Sugar Oatmeal (10ct) 15.1oz | RALSTON FOODS APPLE & CINNAMON INSTANT OATMEAL (10 CT) 12.3 OZ | 591 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Kellogg's Frosted Blueberry Pop Tarts (8 pk) 14.7 oz | KELLOGG'S POP TART BROWN SUGAR CINNAMON 8 CT BOX 14 OZ | 637 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: CAKES PIES AND PASTRIES | Category: CAKES PIES AND PASTRIES | Category: CAKES PIES AND PASTRIES | 18 oz | ||||||||
| Hostess Chocolate Zinger 12.7 oz 10 ct | HOSTESS CHOCOLATE ZINGERS 10 CT 12.7 OZ or Hostess Glazed Donettes 3.7 oz. | 295 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Cloverhill Chocolate Iced Honey Bun 4.75 oz | MRS. FRESHLEY'S HONEY BUNS 6 CT 10.5 OZ | 385 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Otis Spunkmeyer Marble Loaf Cake 3.5 oz | MRS. FRESHLEY'S SWISS ROLLS 12 CT 12 OZ | 741 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: PREPARED AND PRESERVED FOODS | Category: PREPARED AND PRESERVED FOODS | Category: PREPARED AND PRESERVED FOODS | 16 oz | ||||||||
| Velveeta 9 oz. Cheesy Bowls Bacon Mac & Cheese | VELVEETA ULTIMATE CHEESEBURGER MAC SKILLET SINGLE 9 OZ | 691 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| O'Brien's Beef Stick Hickory Smoked Twin Pak 1.125oz | O'BRIEN'S BEEF SALAMI STICK 5 OZ | 937 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Knorr Rice Sides White Cheddar Queso Rice & Pasta 5.6 oz | ZATARAIN BIG EASY DIRTY RICE 8.8 OZ | 859 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Hormel Compleats Beef Pot Roast 9 oz | HORMEL COMPLEATS SALISBURY STEAK 9 OZ | 753 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: CHEESE | Category: CHEESE | Category: CHEESE | 16 oz | ||||||||
| Velveeta Sharp Cheddar Spread 2 oz | OLD FASHIONED BACON SQUEEZE CHEESE 16 OZ | 549 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: SAUCES AND SPREADS AND CONDIMENTS | Category: SAUCES AND SPREADS AND CONDIMENTS | Category: SAUCES AND SPREADS AND CONDIMENTS | 16 oz | ||||||||
| Kraft Mayonnaise 12oz | LEE KUM KEE SRIRACHA MAYO 15 OZ | 691 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Kraft Ranch Salad Dressing Packet 1.5 oz | HIDDEN VALLEY ORIGINAL RANCH 1.5 OZ | 493 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Taco Bell Original Seasoning Mix 1.4 oz | McCORMICK BURRITO SEASONING MIX 1.62 OZ | 283 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: NUTS OR DRIED FRUITS | Category: NUTS OR DRIED FRUITS | Category: NUTS OR DRIED FRUITS | 16 oz | ||||||||
| King Nut Cinnamon Peanuts 16oz | MR. NATURE BUTTER TOFFEE PEANUTS 3.5 OZ | 473 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Zachary Holiday Bridge Mix 5 oz | ZACHARY BRIDGE MIX 5 OZ | 519 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Kar's Nut 'N Yogurt Trail Mix 7 oz | MR. NATURE MIX N'YOGURT 4 OZ | 543 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: CRACKERS | Category: CRACKERS | Category: CRACKERS | 16 oz | ||||||||
| Cheez-It Hot & Spicy Crackers 1.5 oz | CHEEZ-IT HOT & SPICY TABASCO 1.5 OZ | 549 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Pepperidge Farm Goldfish Flavor Blasted Xplosive Pizza 6.6 oz | BAKERS HARVEST WHEAT CRACKERS 9.1 OZ | 681 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Austin Pepperjack on Saltines (8 pk) 1.38 oz | LANCE TOAST CHEE SPICY CHEDDAR 8 PACK 11 OZ | 127 | $0.00 | 0 | BX | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: SWEET BISCUITS OR COOKIES | Category: SWEET BISCUITS OR COOKIES | Category: SWEET BISCUITS OR COOKIES | 16 oz | ||||||||
| Keebler Fudge Stripes Cookies 11.5 oz | No alternate product allowed. | 691 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Bud's Best Candy 'n Cookies - Butterfinger Mini Cookies 5.5 oz | LIL' DUTCH MAID ICED OATMEAL COOKIES 5 OZ | 281 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: SNACK FOOD | Category: SNACK FOOD | Category: SNACK FOOD | 16 oz | ||||||||
| Fritos Chili Cheese Corn Chips 10.5 oz | SHEARER'S KETTLE CREEK CORN CHIP 7 OZ | 873 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Ruffles Cheddar & Sour Cream Potato Chips 5.5 oz | SHEARER'S BARREL OF FUN CHEDDAR & SOUR CREAM CHIP 8 OZ | 935 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Kraft Chocolate Pudding Cup (4 pk) 3.5 oz | REAL FRESH VANILLA PUDDING 4 PACK 14 OZ | 851 | $0.00 | 0 | PK | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Category: CANDY | Category: CANDY | Category: CANDY | 16 oz | ||||||||
| Snickers Peanut Butter Squared 1.78 oz | Snickers Peanut Butter Square Mini's Bag 11.5oz | 569 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Whoppers 12 oz | No alternate product allowed. | 651 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Hershey's Milk Duds 10 oz | No alternate product allowed. | 991 | $0.00 | 0 | EA | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Vendor Name: | |||||||||||
| Total: | $0.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | The total cost per ounce x quantity is worth 70% of the total score | |||||||
| Vendor Signature: |
Total Commission Refunded to PADOC (20% minimum) 0.00% The commission is worth 30% of the total score
Total Score ERROR:#DIV/0!
File details come from the government source that posted it. Updated .