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

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.
DescriptionAlternative/Comparable ItemBid ItemQuantityUnit PriceCategory Size Limitation
Enter the Number of Ounces per ItemUOMTotal PriceCost per OunceCost per Ounce x Quantity
Category: SOUPSCategory: SOUPSCategory: SOUPS3 oz
Maruchan Roast Chicken Flavor Ramen 3 ozNISSIN CHICKEN RAMEN 3 OZ184$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Maruchan Roast Beef Flavor Ramen 3 ozNISSIN BEEF RAMEN 3 OZ128$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: BEVERAGESCategory: BEVERAGESCategory: BEVERAGES16 oz
Maxwell House Dark Roast Espresso 4 ozBOSTON'S BEST PREMIUM COFFEE 8 OZ or Folgers Traditional Roast 8 oz.1185$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Hawaiian Punch Singles To Go Fruit Juicy Red (8 pk) .74 ozHAWAIIAN PUNCH SUGAR FREE JUICY RED SINGLES TO GO (8 CT) .75 OZ757$0.000BX$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Hawaiian Punch Singles To Go SF Berry Blue Typoon (8 pk) .95ozWYLER'S LIGHT W/CAFFEINE TOTALLY TROPICAL SINGLES TO GO 6CT .70 OZ721$0.000BX$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: BREAKFAST FOODSCategory: BREAKFAST FOODSCategory: BREAKFAST FOODS20 oz
Quaker Maple Brown Sugar Granola Bar 1.26ozFLAVOR KIST CRUNCHY OATS N HONEY GRANOLA BAR SINGLE 1.5 OZ483$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Quaker Maple Brown Sugar Oatmeal (10ct) 15.1ozRALSTON FOODS APPLE & CINNAMON INSTANT OATMEAL (10 CT) 12.3 OZ591$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Kellogg's Frosted Blueberry Pop Tarts (8 pk) 14.7 ozKELLOGG'S POP TART BROWN SUGAR CINNAMON 8 CT BOX 14 OZ637$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: CAKES PIES AND PASTRIESCategory: CAKES PIES AND PASTRIESCategory: CAKES PIES AND PASTRIES18 oz
Hostess Chocolate Zinger 12.7 oz 10 ctHOSTESS CHOCOLATE ZINGERS 10 CT 12.7 OZ or Hostess Glazed Donettes 3.7 oz.295$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Cloverhill Chocolate Iced Honey Bun 4.75 ozMRS. FRESHLEY'S HONEY BUNS 6 CT 10.5 OZ385$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Otis Spunkmeyer Marble Loaf Cake 3.5 ozMRS. FRESHLEY'S SWISS ROLLS 12 CT 12 OZ741$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: PREPARED AND PRESERVED FOODSCategory: PREPARED AND PRESERVED FOODSCategory: PREPARED AND PRESERVED FOODS16 oz
Velveeta 9 oz. Cheesy Bowls Bacon Mac & CheeseVELVEETA ULTIMATE CHEESEBURGER MAC SKILLET SINGLE 9 OZ691$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
O'Brien's Beef Stick Hickory Smoked Twin Pak 1.125ozO'BRIEN'S BEEF SALAMI STICK 5 OZ937$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Knorr Rice Sides White Cheddar Queso Rice & Pasta 5.6 ozZATARAIN BIG EASY DIRTY RICE 8.8 OZ859$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Hormel Compleats Beef Pot Roast 9 ozHORMEL COMPLEATS SALISBURY STEAK 9 OZ753$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: CHEESECategory: CHEESECategory: CHEESE16 oz
Velveeta Sharp Cheddar Spread 2 ozOLD FASHIONED BACON SQUEEZE CHEESE 16 OZ549$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: SAUCES AND SPREADS AND CONDIMENTSCategory: SAUCES AND SPREADS AND CONDIMENTSCategory: SAUCES AND SPREADS AND CONDIMENTS16 oz
Kraft Mayonnaise 12ozLEE KUM KEE SRIRACHA MAYO 15 OZ691$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Kraft Ranch Salad Dressing Packet 1.5 ozHIDDEN VALLEY ORIGINAL RANCH 1.5 OZ493$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Taco Bell Original Seasoning Mix 1.4 ozMcCORMICK BURRITO SEASONING MIX 1.62 OZ283$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: NUTS OR DRIED FRUITSCategory: NUTS OR DRIED FRUITSCategory: NUTS OR DRIED FRUITS16 oz
King Nut Cinnamon Peanuts 16ozMR. NATURE BUTTER TOFFEE PEANUTS 3.5 OZ473$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Zachary Holiday Bridge Mix 5 ozZACHARY BRIDGE MIX 5 OZ519$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Kar's Nut 'N Yogurt Trail Mix 7 ozMR. NATURE MIX N'YOGURT 4 OZ543$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: CRACKERSCategory: CRACKERSCategory: CRACKERS16 oz
Cheez-It Hot & Spicy Crackers 1.5 ozCHEEZ-IT HOT & SPICY TABASCO 1.5 OZ549$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Pepperidge Farm Goldfish Flavor Blasted Xplosive Pizza 6.6 ozBAKERS HARVEST WHEAT CRACKERS 9.1 OZ681$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Austin Pepperjack on Saltines (8 pk) 1.38 ozLANCE TOAST CHEE SPICY CHEDDAR 8 PACK 11 OZ127$0.000BX$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: SWEET BISCUITS OR COOKIESCategory: SWEET BISCUITS OR COOKIESCategory: SWEET BISCUITS OR COOKIES16 oz
Keebler Fudge Stripes Cookies 11.5 ozNo alternate product allowed.691$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Bud's Best Candy 'n Cookies - Butterfinger Mini Cookies 5.5 ozLIL' DUTCH MAID ICED OATMEAL COOKIES 5 OZ281$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: SNACK FOODCategory: SNACK FOODCategory: SNACK FOOD16 oz
Fritos Chili Cheese Corn Chips 10.5 ozSHEARER'S KETTLE CREEK CORN CHIP 7 OZ873$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Ruffles Cheddar & Sour Cream Potato Chips 5.5 ozSHEARER'S BARREL OF FUN CHEDDAR & SOUR CREAM CHIP 8 OZ935$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Kraft Chocolate Pudding Cup (4 pk) 3.5 ozREAL FRESH VANILLA PUDDING 4 PACK 14 OZ851$0.000PK$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Category: CANDYCategory: CANDYCategory: CANDY16 oz
Snickers Peanut Butter Squared 1.78 ozSnickers Peanut Butter Square Mini's Bag 11.5oz569$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Whoppers 12 ozNo alternate product allowed.651$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Hershey's Milk Duds 10 ozNo alternate product allowed.991$0.000EA$0.00ERROR:#DIV/0!ERROR:#DIV/0!
Vendor Name:
Total:$0.00ERROR:#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 .