Attachment 1 MBL Cost Response.xls

XLS spreadsheet 112 KB Posted

Attached to
Commercial Food Products
Solicitation number
SRC000456
Issued by
Stark County, North Dakota

About this file

This file is a Market Basket Cost Response template for North Dakota Term Contract (TC) 053 for Commercial Food Products under RFP 110.7-20-100, administered by the State of North Dakota through its State Procurement Office. The solicitation seeks to award contracts to three vendors to provide commercial food products on a statewide basis. Bidders must complete two tabs within the spreadsheet template by entering pricing information only in non-shaded columns (G through O) to be considered responsive. All commercial food product items numbered in Column B and described in Column D must be bid to achieve responsiveness. The template specifies that alternate units of measure differing from the named standard unit may not be considered responsive, with only fractional deviations acceptable. The price date for the market basket is October 16, 2020. Part 1 of the cost response includes four sample items (eggs, egg scramble mix, ground beef, and apples) with a sample total of $132,103.70, while Part 2 contains 111 additional food product line items ranging from fresh produce and proteins to pantry staples and beverages, with estimated usage quantities provided for each item.

Vendors must provide defined costs for each product line item and indicate whether products are stock, non-stock, or special order status. The template requires bidders to insert a percentage markup that will be applied to the defined cost for all items not listed in the market basket. Vendors are encouraged to provide supplemental pricing information related to contract discounts and may report total incentives and rebates based on the market basket total. The multiple-award structure is designed to enable the State to procure products at the lowest possible price from all three vendors, with the intention of achieving cost savings for entities such as the Department of Corrections and other state agencies with limited budgets. No modifications to the market basket cost response template are permitted beyond the designated non-shaded columns; any unauthorized alterations may result in the bid being determined non-responsive. The state's approach prioritizes competitive pricing through multiple vendors rather than single-source procurement.

View the file

Other files

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

Sample Market Basket Cost

SAMPLE Part 1 -NOTE TWO TABS TO BE COMPLETED FOR COST RESPONSES
BIDDER COMPANY NAME: ____________________________________________
FOOD BID COST RESPONSES
NORTH DAKOTA TERM CONTRACT (TC) 053
COMMERICAL FOOD PRODUCTS RFP 110.7-20-100
Bidder's Instructions for completion of Bid Cost Response
1. RESPOND BY ENTERING/INPUTTING RESPONSES INTO NON-SHADED COLUMNS ONLY. BIDDER MUST COMPLETE: COLUMNS: G thru O WITH REQUIRED BIDDER INPUT TO BE CONSIDERED RESPONSIVE. NOTE THESE COLUMNS HAVE AN ASTERISK.
2. COLUMN E: PACKAGE SIZE as named in (COLUMN E) is critical - Alternate units of measure that differ from the named STANDARD UNIT may not be considered responsive. Only fractional deviations of the named Standard Unit will be considered responsive.
3. Any modification of the Market Basket Cost Response, other than under the heading "BIDDER MAY ENTER INTO NON-SHADED COLUMNS ONLY" may result in the bid being determined to be non-responsive. Do not add columns or alter any part of these Commercial Food Bid Cost Responses.
ALL COMMERCIAL FOOD PRODUCT ITEMS NUMBERED IN COLUMN B AND DESCRIBED IN COLUMN D MUST BE BID TO BE CONSIDERED RESPONSIVESAMPLESAMPLESAMPLESAMPLESAMPLESAMPLESAMPLESAMPLESAMPLE
Columns AColumns BColumns CColumns DColumn EColumn FColumn G *Column H *Column I*Column J *Column K*Column L*Column M*Column N*Column O*Column PColumn QColumn R
#MFG Product No.LabelFOOD PRODUCT DESCRIPTIONPackage SizeUnit of MeasureProduct BrandSupplier or Manuf. Product #Ordering Product #Stock, Non-Stock or Special OrderSupplier Cost/Cs (Defined Cost)Comparable Case AdjustmentVendor Case AdjustmentCase AdjustmentVendor Price Adjustment to current Package/SizeEST. USAGETOTAL STATE PRICERemarks
174865249836WHLFCLSEGG SHELL MED GR AA USDA WHT1/15 DZCSMULTIPLE SOURCES080003823021Stock$10.50111.00$10.502225.0$23,362.50
234730-18927-00WHLFRELEGG SCRAMBLE MIX CTN6/5 LBCSMULTIPLE SOURCES610673831065Stock$40.00111.00$40.00682.0$27,280.00
366838FIRECLSBEEF GRND BULK 81/19 CHUB FRS4/10#AVLBMULTIPLE SOURCES4482276567077Non-Stock$3.0040140.00$120.00336.0$40,320.00
42188530SYS CLSAPPLE RED DEL FCY WASH FRESH1/163 CTCSMULTIPLE SOURCES0126337480247Special Order$35.001631750.93$32.601262.0$41,141.20
Total$132,103.70
Vendors insert the percentage markup that will be added to the defined cost. This % markup will be used to determine the Defined Cost for all items not listed in the MBL.3%Total amount of Incentives and Rebates based off the total of this market basket.$0.00
Vendors are encouraged to provide supplimental pricing information related to discounts given for this contract.Do not include any early payment incentives.
Grand Total is the Total minus rebates and incentives amount.$0.00
Vendors insert the percentage markup that will be added to the defined cost. This % markup will be used to determine the Defined Cost for all items listed in the MBL.%

&R&P

Market Basket Cost Response

Part 2-NOTE TWO TABS TO BE COMPLETED FOR COST RESPONSES
BIDDER COMPANY NAME: ____________________________________________
FOOD BID COST RESPONSES
NORTH DAKOTA TERM CONTRACT (TC) 053
COMMERICAL FOOD PRODUCTS RFP 110.7-20-100
Bidder's Instructions for completion of Bid Cost Response
1. RESPOND BY ENTERING/INPUTTING RESPONSES INTO NON-SHADED COLUMNS ONLY. BIDDER MUST COMPLETE: COLUMNS: G thru O WITH REQUIRED BIDDER INPUT TO BE CONSIDERED RESPONSIVE. NOTE THESE COLUMNS HAVE AN ASTERISK.
2. COLUMN E: PACKAGE SIZE as named in (COLUMN E) is critical - Alternate units of measure that differ from the named STANDARD UNIT may not be considered responsive. Only fractional deviations of the named Standard Unit will be considered responsive.
3. Any modification of the Market Basket Cost Response, other than under the heading "BIDDER MAY ENTER INTO NON-SHADED COLUMNS ONLY" may result in the bid being determined to be non-responsive. Do not add columns or alter any part of these Commercial Food Bid Cost Responses.
ALL COMMERCIAL FOOD PRODUCT ITEMS NUMBERED IN COLUMN B AND DESCRIBED IN COLUMN D MUST BE BID TO BE CONSIDERED RESPONSIVEPrice Date for this Market Basket is 10/16/2020
Columns AColumns BColumns CColumns DColumn EColumn FColumn G *Column H *Column I*Column J *Column K*Column L*Column M*Column N*Column O*Column PColumn QColumn R
#MFG Product No.LabelFOOD PRODUCT DESCRIPTIONPackage SizeUnit of MeasureProduct BrandSupplier or Manuf. Product #Ordering Product #Stock, Non-Stock or Special OrderSupplier Cost/Cs (Defined Cost)Comparable Case AdjustmentVendor Case AdjustmentCase AdjustmentVendor Price Adjustment to current Package/SizeEST. USAGETOTAL STATE PRICERemarks
12188530SYS CLSAPPLE RED DEL FCY WASH FRESH1/125 CTCS0.00$0.001262.0$0.00
271923-78536GILSTERCEREAL HONEY NUT1/20 LBCS0.00$0.00781.0$0.00
33533528SYS RELPEA GREEN6/10 CTCS0.00$0.00785.0$0.00
40SYS IMPORANGE NAVEL FANCY FRESH1/138 CTCS0.00$0.001300.0$0.00
5I07SYS IMPPOTATO TATER BARREL NW6/5 LBCS0.00$0.00857.0$0.00
60SYS NATCARROT BABY CUT PLD4/5 LBCS0.00$0.001035.0$0.00
73007SAHAR BJUICE APPLE SHELF STABLE96/4 OZCS0.00$0.00692.0$0.00
8SUNKISTSYS IMPORANGE VALENCIA FANCY FRESH1/138 CTCS0.00$0.00745.0$0.00
93677739SYS CLSPOTATO MASH COMP SAFE T CAN6/5.31LBCS0.00$0.00381.0$0.00
10P1166156PACKERBANANA PETITE GRN TIP FRESH1/150 CTCS0.00$0.00695.0$0.00
111637BUSHBEAN BAKED VEGETARIAN6/#10CS0.00$0.00479.0$0.00
129060DOLESALAD FRUIT TROPICAL JCE6/#10CS0.00$0.00358.0$0.00
13SYCBY99SYS CLSTOMATO DICED IN JUICE6/#10CS0.00$0.00562.0$0.00
143548393INTLRELORANGE MANDARIN BRKN LS6/#10CS0.00$0.00431.0$0.00
150BBRLCLSCHEESE AMER 160 SLI YEL4/5 LBCS0.00$0.00295.0$0.00
160CASASOLCHEESE CHDR MILD FCY SHRD YEL4/5LBCS0.00$0.00258.0$0.00
173984952SYS CLSCORN WHL KERNEL SUPER SWEET1/30 LBCS0.00$0.00427.0$0.00
187486502808HSE RECCRACKER SALTINE500/2 PKCS0.00$0.00825.0$0.00
190SYS CLSBEAN GREEN CUT REALLY GREEN6/#10CS0.00$0.00449.0$0.00
204987343SYS CLSPEACH YC DICED CH PEAR JCE6/#10CS0.00$0.00251.0$0.00
2129502SYINTLCLSTUNA LIGHT SKIPJACK CHUNK WTR6/66.5OZCS0.00$0.00184.0$0.00
2258072000GOLDMDLFLOUR WHEAT WHL STONE GRND1/50 LBCS0.00$0.00783.0$0.00
232817SAHAR BJUICE PRUNE 100% ASEPTIC12/46 OZCS0.00$0.00174.0$0.00
24403434SYS CLSSUGAR GRANULATED XFINE CANE1/50 LBCS0.00$0.00367.0$0.00
253532975SYS CLSVEGETABLE MIX 5-WAY GR A1/30 LBCS0.00$0.00360.0$0.00
2642050SWTPLUSSUGAR SUB PACKET BLUE2000/1 GMCS0.00$0.00428.0$0.00
2778530GILSTERCEREAL CORN FLAKES1/20 LBCS0.00$0.00414.0$0.00
2871923-78531GILSTERCEREAL BRAN 40% FLAKES1/20 LBCS0.00$0.00414.0$0.00
294030284SYS IMPSAUCE TOMATO FCY CAL6/#10CS0.00$0.00415.0$0.00
301.0734730409e+013SYS CLSPOTATO FRY KK 5/16 GR A6/5LBCS0.00$0.00518.0$0.00
316738799321DAKOTAPASTA ELBOW MACARONI2/10 LBCS0.00$0.00511.0$0.00
325614BKRSCLSPANCAKE BTRMLK HT&SRV 4 5/8"144/1.58OZCS0.00$0.00381.0$0.00
337486532277CASASOLBEAN CHILI PINTO MEXICAN6/#10CS0.00$0.00429.0$0.00
34630113LABELLAPASTA NOODLE EGG XWIDE2/5LBCS0.00$0.00570.0$0.00
352811SAHAR BJUICE ORANGE 100% ASEPTIC12/46 OZCS0.00$0.00301.0$0.00
363533056SYS CLSBEAN GREEN CUT GR A1/30 LBCS0.00$0.00336.0$0.00
371960043585AUNTJEMTOAST FRENCH STICK180/.88 OZCS0.00$0.00445.0$0.00
3810071179478089SIMPLOTPOTATO FRY WDG SKON 8CUT SPCY6/5 LBCS0.00$0.00325.0$0.00
395885678090HSE RECPEANUT BUTTER CREAMY CUP200/.5 OZCS0.00$0.00391.0$0.00
40152003201SYS CLSVEGETABLE BLEND CALIF GR A6/10 CTCS0.00$0.00256.0$0.00
413404805SBSAHAR BJUICE GRAPE48/5.5 OZCS0.00$0.00318.0$0.00
42E45SYS IMPPOTATO H/BRN TRIANGLE 2 OZ NW6/5 LBCS0.00$0.00323.0$0.00
4378532GILSTERCEREAL RICE CRISP1/20 LBCS0.00$0.00280.0$0.00
442266294SYS CLSBEAN GREEN FRENCH CUT IQF6/10 CTCS0.00$0.00300.0$0.00
4579871060855SYS RELSAUCE CHEESE AGED CHED ZTF6/#10CS0.00$0.00176.0$0.00
4613126HHLSUPPLEMENT MIX PROPASS PROTEIN4/7.5 OZCS0.00$0.00152.0$0.00
47443SYS RELSYRUP PANCAKE AND WAFFLE4/1 GALCS0.00$0.00367.0$0.00
4833328SYS RELSAUCE CHEESE AGED CHDR ZTF6/#10CS0.00$0.00194.0$0.00
497486510412SYS CLSBEAN KIDNEY DARK RED6/#10CS0.00$0.00315.0$0.00
5010020431PORTBTYCOD RECT BRD PRCK PUFI CN 3 OZ2/5 LBCS0.00$0.00229.0$0.00
513960093SYS CLSPEA & CARROT GR A1/30 LBCS0.00$0.00271.0$0.00
5299957-WFSWHLFCLSMARGARINE SOLID ALL VEG30/1 LBCS0.00$0.00484.0$0.00
5399880-COMSYS RELSHORTENING FRY LIQ CLR ZTF1/35 LBCS0.00$0.00354.0$0.00
540SYS IMPPOTATO BAKING IDAHO 110 CT.1/50 LBCS0.00$0.00496.0$0.00
552812SAHAR BJUICE APPLE 100% ASEPTIC12/46 OZCS0.00$0.00255.0$0.00
5614480SYS CLSSPICE PEPPER PACKET .1 GM6/1000CTCS0.00$0.00249.0$0.00
571877026SYS CLSBEAN WAX CUT P12/2 LBCS0.00$0.00283.0$0.00
581054964SYS CLSCARROT DICED GR A P12/2 LBCS0.00$0.00379.0$0.00
593327SYS IMPTHICKENER FOOD1/25LBCS0.00$0.0074.0$0.00
6012888-SYSHSE RECSYRUP TABLE MAPLE FLAVORED CUP200/1.5 OZCS0.00$0.00215.0$0.00
613327848SYS CLSPOTATO PEARL EXCEL12/28 OZCS0.00$0.00109.0$0.00
6291291SYS CLSPOTATO H/BRN DEHY GLDN GRL6/37.5OZCS0.00$0.00142.0$0.00
634604120SYS CLSFRUIT COCKTAIL CH IN PEARJUICE6/#10CS0.00$0.00130.0$0.00
6423527601425HSE RECCEREAL HOT OAT QUICK12/42 OZCS0.00$0.00173.0$0.00
6513483-SYSWHLFCLSMARGARINE SPREAD ZTF900/5 GMCS0.00$0.00288.0$0.00
6639022BAKEBOYBISCUIT BUTTERMILK 3 IN BKD96/2.3 OZCS0.00$0.00202.0$0.00
671008473SYS IMPPOTATO BAKING IDAHO 100CT FRSH1/50 LBCS0.00$0.00408.0$0.00
68610800EQUALSUGAR SUB BLUE PACKET1/2000CTCS0.00$0.00202.0$0.00
693533494SYS RELCORN WHL KERNEL1/30 LBCS0.00$0.00202.0$0.00
7012012BAKEBOYDOUGH ROLL CINNAMON SWEET120/2.5 OZCS0.00$0.00186.0$0.00
7172433HSE RECJELLY ASST 160G/160MF/80STR400/.5 OZCS0.00$0.00236.0$0.00
72R1YK259Z0SYS IMPRICE PARBOILED PERFECT1/25 LBCS0.00$0.00371.0$0.00
731111518200PROMISEMARGARINE SPREAD CUP600/5 GMCS0.00$0.00223.0$0.00
7411061RUFFLESCHIP POTATO RIDGED ORIG SS104/1 OZCS0.00$0.00160.0$0.00
75R2PX25QC0PAREXCLRICE BROWN PARBOILED WHLGRN QC1/25 LBCS0.00$0.00382.0$0.00
7611547000GMMIX MUFFIN BLUEBERRY COMPLT6/78 OZCS0.00$0.0068.0$0.00
772813SAHAR BJUICE GRAPE 100% ASEPTIC12/46OZCS0.00$0.00162.0$0.00
7838900-03073DOLEPEACH DICED IN 100% FRUIT JUIC36/4 OZCS0.00$0.00253.0$0.00
796004805SBSAHAR BJUICE ORANGE48/5.5 OZCS0.00$0.00194.0$0.00
810SYS IMPAPPLE GLDN XFCY FRSH1/113 CTCS0.00$0.00165.0$0.00
823604805SBSAHAR BJUICE APPLE48/5.5 OZCS0.00$0.00182.0$0.00
833010SAHAR BJUICE ORG SHELF STABLE96/4 OZCS0.00$0.00154.0$0.00
841.30009866e+011SYS CLSKETCHUP PKT (SYS/HNZ)1000/9 GMCS0.00$0.00305.0$0.00
8563457LOSCABOBURRITO CHEESE AND BEAN48/5.48CS0.00$0.00132.0$0.00
864891883SYS CLSPEAR DICED IN PEAR JCE6/#10CS0.00$0.00110.0$0.00
87600732LABELLAPASTA SPAGHETTI 10 IN2/10 LBCS0.00$0.00195.0$0.00
8820031OCNSPRYJUICE CRANBERRY DIET8/64OZCS0.00$0.00156.0$0.00
890PACKERBROCCOLI CROWN ICELS ASIAN CUT1/20 LBCS0.00$0.00170.0$0.00
906100118ECOLABRINSE LIQUID ADDTV FAST DRYING2/5QTCS0.00$0.0020.0$0.00
917486510630SYS CLSCARROT DICED FCY6/#10CS0.00$0.00196.0$0.00
9270462SYBKRSCLSDOUGH COOKIE CHOC CHIP 1OZ240/1OZCS0.00$0.00150.0$0.00
9386970KOCHCHICKEN TENDER FRTR HMSTYL CKD2/5LBCS0.00$0.0089.0$0.00
94553DOLEPINEAPPLE TIDBIT JCE FCY6/#10CS0.00$0.00110.0$0.00
95IL50SYS IMPPOTATO TATER BARREL6/5 LBCS0.00$0.00186.0$0.00
963010021618KEEBLERCRACKER OYSTER1/10 LBCS0.00$0.00190.0$0.00
977486506759SYS CLSPEANUT BUTTER CREAMY1/35 LBCS0.00$0.0063.0$0.00
987486510694SYS CLSVEGETABLE MIXED FCY6/#10CS0.00$0.00163.0$0.00
9919511BAKEBOYDOUGH DUMPLING1/20 LBCS0.00$0.00121.0$0.00
100600728LABELLAPASTA SHELL MED2/10 LBCS0.00$0.00171.0$0.00
1015610BKRSCLSWAFFLE SQUARE HT&SRV 4"144/1.4 OZCS0.00$0.00203.0$0.00
1021.30004174e+011HEINZSOUP CREAM OF CELERY12/50 OZCS0.00$0.00120.0$0.00
1034015657SYS CLSAPPLESAUCE FANCY6/#10CS0.00$0.00146.0$0.00
104SYIHA99SYS IMPSAUCE TOMATO MW6/#10CS0.00$0.00192.0$0.00
1057486510577SYS CLSCORN CREAM STYLE GOLDEN FCY6/#10CS0.00$0.00146.0$0.00
10672410SYS CLSJELLY GRAPE CONCORD6/#10CS0.00$0.0088.0$0.00
1082709543SYS CLSPEAR DICED EXTRA LS CALIF6/#10CS0.00$0.0078.0$0.00
1097486511434SYS CLSBEAN WAX CUT FANCY6/#10CS0.00$0.00148.0$0.00
1103009SAHAR BJUICE GRAPE96/4 OZCS0.00$0.00116.0$0.00
1117486510619SYS CLSBEET DICED FCY6/#10CS0.00$0.00151.0$0.00
Total$0.00
Vendors insert the percentage markup that will be added to the defined cost. This % markup will be used to determine the Defined Cost for all items not listed in the MBL.%Total amount of Incentives and Rebates based off the total of this market basket.$0.00
Vendors are encouraged to provide supplimental pricing information related to discounts given for this contract.Do not include any early payment incentives.
Grand Total is the Total minus rebates and incentives amount.$0.00

&R&P

File details come from the government source that posted it. Updated .