AttachmentEPricingSpreadsheet.xls
XLS spreadsheet 73 KB Posted
- Solicitation number
- HDEC02-07-R-0007
- Issued by
-
Defense Commissary Agency
About this file
DeCA Solicitation HDEC02-07-R-0007 Attachment E Pricing Spreadsheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| AttachmentE-Amend0003.xls | XLS spreadsheet | |
| 07R0007Amend0003.doc | DOC document | |
| 07R0007Amend0002.doc | DOC document | |
| AttachmentE-Amend0002.xls | XLS spreadsheet | |
| 07R0007Amend0001.doc | DOC document | |
| 07R0007.doc | DOC document | |
| NoticetoSuppliers.doc | DOC 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
EUROPEAN REGION
| Solicitation: HDEC02-07-R-0007 | ATTACHMENT E (EUROPEAN REGION COMMISSARIES) | |||||||||||||||||||
| Offeror: | Insert Contractor Name Here | FRESH BEEF AND FROZEN COARSE GROUND BEEF | ||||||||||||||||||
| SUPPLIES/SERVICES | BASE PERIOD (24-Months) | OPTION YEAR 1 | OPTION YEAR 2 | OPTION YEAR 3 | ||||||||||||||||
| Line Item Number | ITEM DESCRIPTION | Universal Product Code (UPC) | Size | Estimated Quantity | Base Price | Special Factor | Unit Price | Estimated Amount | Base Price | Special Factor | Unit Price | Estimated Amount | Base Price | Special Factor | Unit Price | Estimated Amount | Base Price | Special Factor | Unit Price | Estimated Amount |
| MANDATORY ITEMS PRIMALS AND SUBPRIMALS (FRESH, CHILLED) COARSE GROUND (FROZEN) | MANDATORY ITEMS STARTING WITH CLINS ENDING IN "AA" and CONTINUE THROUGH CLINS ENDING IN "AY" | |||||||||||||||||||
| 0001AA | BEEF RIB, RIB-EYE ROLL, LIP-ON, BONE-IN, WEIGHT 12-19 LBS; IMPS 109E, U-1. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | Insert UPC Here | LBS | 80,000 | $5.28 | $0.00 | $5.28 | $422,400.00 | $5.28 | $0.00 | $5.28 | $422,400.00 | $5.28 | $0.00 | $5.28 | $422,400.00 | $5.28 | $0.00 | $5.28 | $422,400.00 |
| 0001AB | BEEF RIB, RIB-EYE ROLL, LIP-ON, BONELESS, HEAVY, WT RANGE 12-18 LBS; IMPS 112A, U-16. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | Insert UPC Here | LBS | 500,000 | $5.83 | $0.00 | $5.83 | $2,915,000.00 | $5.83 | $0.00 | $5.83 | $2,915,000.00 | $5.83 | $0.00 | $5.83 | $2,915,000.00 | $5.83 | $0.00 | $5.83 | $2,915,000.00 |
| 0001AC | BEEF CHUCK SHOULDER CLOD, 2 PC (BLADE & ARM), WEIGHT 10-16 LBS; IMPS 114A, U81. | Insert UPC Here | LBS | 640,000 | $1.52 | $0.00 | $1.52 | $972,800.00 | $1.52 | $0.00 | $1.52 | $972,800.00 | $1.52 | $0.00 | $1.52 | $972,800.00 | $1.52 | $0.00 | $1.52 | $972,800.00 |
| 0001AD | BEEF CHUCK ROLL, WEIGHT 15-23 LBS; IMPS 116A, U-80. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | Insert UPC Here | LBS | 600,000 | $1.72 | $0.00 | $1.72 | $1,032,000.00 | $1.72 | $0.00 | $1.72 | $1,032,000.00 | $1.72 | $0.00 | $1.72 | $1,032,000.00 | $1.72 | $0.00 | $1.72 | $1,032,000.00 |
| 0001AE | BEEF CHUCK TENDERS, WEIGHT 2-4 LBS; IMPS 116B, U-36. Block-cut nose 1-3" thick. Block-cut tail 1-3" thick. | Insert UPC Here | LBS | 400,000 | $1.66 | $0.00 | $1.66 | $664,000.00 | $1.66 | $0.00 | $1.66 | $664,000.00 | $1.66 | $0.00 | $1.66 | $664,000.00 | $1.66 | $0.00 | $1.66 | $664,000.00 |
| 0001AF | BEEF BRISKET, FLAT CUT, BONELESS, WEIGHT 5-9 LBS; IMPS 120A, U-82. | Insert UPC Here | LBS | 100,000 | $2.32 | $0.00 | $2.32 | $232,000.00 | $2.32 | $0.00 | $2.32 | $232,000.00 | $2.32 | $0.00 | $2.32 | $232,000.00 | $2.32 | $0.00 | $2.32 | $232,000.00 |
| 0001AG | BEEF PLATE, INSIDE SKIRT (TRANSVERSUS ABDOMINOUS) SKINNED, WT RANGE 3-5 LBS; IMPS 121D, U-8. | Insert UPC Here | LBS | 30,000 | $2.40 | $0.00 | $2.40 | $72,000.00 | $2.40 | $0.00 | $2.40 | $72,000.00 | $2.40 | $0.00 | $2.40 | $72,000.00 | $2.40 | $0.00 | $2.40 | $72,000.00 |
| 0001AH | BEEF SHORT PLATE, SHORT RIBS, TRIMMED, WT RANGE 3-5 LBS; IMPS 123A, U-9. | Insert UPC Here | LBS | 42,000 | $1.75 | $0.00 | $1.75 | $73,500.00 | $1.75 | $0.00 | $1.75 | $73,500.00 | $1.75 | $0.00 | $1.75 | $73,500.00 | $1.75 | $0.00 | $1.75 | $73,500.00 |
| 0001AJ | BEEF ROUND, SHANK-OFF, PARTIALLY BONELESS, IMPS 161, U-11. | Insert UPC Here | LBS | 6,000 | $1.57 | $0.00 | $1.57 | $9,420.00 | $1.57 | $0.00 | $1.57 | $9,420.00 | $1.57 | $0.00 | $1.57 | $9,420.00 | $1.57 | $0.00 | $1.57 | $9,420.00 |
| 0001AK | BEEF ROUND, KNUCKLE, PEELED, WT RANGE 8-12 LBS; IMPS 167A, U-12. Block-cut Patella end 1-3" thick, so it is perpendicular to bordering fat sides. | Insert UPC Here | LBS | 525,000 | $1.75 | $0.00 | $1.75 | $918,750.00 | $1.75 | $0.00 | $1.75 | $918,750.00 | $1.75 | $0.00 | $1.75 | $918,750.00 | $1.75 | $0.00 | $1.75 | $918,750.00 |
| 0001AL | BEEF ROUND, TOP (INSIDE), DENUDED, WT RANGE 15-20 LBS; IMPS 169, U-90. | Insert UPC Here | LBS | 1,500,000 | $1.88 | $0.00 | $1.88 | $2,820,000.00 | $1.88 | $0.00 | $1.88 | $2,820,000.00 | $1.88 | $0.00 | $1.88 | $2,820,000.00 | $1.88 | $0.00 | $1.88 | $2,820,000.00 |
| 0001AM | BEEF ROUND, OUTSIDE ROUNDS, WT RANGE 10-16 LBS; IMPS 171B, U-31. | Insert UPC Here | LBS | 300,000 | $1.69 | $0.00 | $1.69 | $507,000.00 | $1.69 | $0.00 | $1.69 | $507,000.00 | $1.69 | $0.00 | $1.69 | $507,000.00 | $1.69 | $0.00 | $1.69 | $507,000.00 |
| 0001AN | BEEF ROUND, EYE OF ROUND, WT RANGE 3-7 LBS; IMPS 171C, U-15. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | Insert UPC Here | LBS | 275,000 | $2.07 | $0.00 | $2.07 | $569,250.00 | $2.07 | $0.00 | $2.07 | $569,250.00 | $2.07 | $0.00 | $2.07 | $569,250.00 | $2.07 | $0.00 | $2.07 | $569,250.00 |
| 0001AP | BEEF LOIN, SHORT LOIN, SHORT-CUT, WT RANGE 15-23 LBS; IMPS 174, U-88. Block-cut. See bottom of spreadsheet for additional information. | Insert UPC Here | LBS | 675,000 | $4.42 | $0.00 | $4.42 | $2,983,500.00 | $4.42 | $0.00 | $4.42 | $2,983,500.00 | $4.42 | $0.00 | $4.42 | $2,983,500.00 | $4.42 | $0.00 | $4.42 | $2,983,500.00 |
| 0001AQ | BEEF LOIN, STRIP LOIN, SHORT-CUT, BONELESS, WT RANGE 8-12 LBS; IMPS 180, U-87. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | Insert UPC Here | LBS | 125,000 | $4.94 | $0.00 | $4.94 | $617,500.00 | $4.94 | $0.00 | $4.94 | $617,500.00 | $4.94 | $0.00 | $4.94 | $617,500.00 | $4.94 | $0.00 | $4.94 | $617,500.00 |
| 0001AR | BEEF LOIN, TOP SIRLOIN BUTT, 2 PC, BONELESS, WT RANGE 13-18 LBS, IMPS 184, U-89. | Insert UPC Here | LBS | 625,000 | $2.25 | $0.00 | $2.25 | $1,406,250.00 | $2.25 | $0.00 | $2.25 | $1,406,250.00 | $2.25 | $0.00 | $2.25 | $1,406,250.00 | $2.25 | $0.00 | $2.25 | $1,406,250.00 |
| 0001AS | BEEF LOIN, TENDERLOIN, FULL, SIDE-MUSCLE ON, DEFATTED, LIGHT, WT RANGE 5 LBS AND UNDER, SELECT; IMPS 189A, U-20. | Insert UPC Here | LBS | 14,000 | $9.03 | $0.00 | $9.03 | $126,420.00 | $9.03 | $0.00 | $9.03 | $126,420.00 | $9.03 | $0.00 | $9.03 | $126,420.00 | $9.03 | $0.00 | $9.03 | $126,420.00 |
| 0001AT | BEEF LOIN, TENDERLOIN BUTT, DEFATTED, WT RANGE 5 LBS AND UNDER, IMPS 191A, U-86. | Insert UPC Here | LBS | 125,000 | $8.39 | $0.00 | $8.39 | $1,048,750.00 | $8.39 | $0.00 | $8.39 | $1,048,750.00 | $8.39 | $0.00 | $8.39 | $1,048,750.00 | $8.39 | $0.00 | $8.39 | $1,048,750.00 |
| 0001AU | BEEF FLANK, FLANK STEAK, WT RANGE 1-3 LBS; IMPS 193, U-21. | Insert UPC Here | LBS | 95,000 | $3.01 | $0.00 | $3.01 | $285,950.00 | $3.01 | $0.00 | $3.01 | $285,950.00 | $3.01 | $0.00 | $3.01 | $285,950.00 | $3.01 | $0.00 | $3.01 | $285,950.00 |
| 0001AV | BEEF SPECIAL TRIM (CAP WEDGE AND PECTORAL), BONELESS, IMPS 139, U-35. | Insert UPC Here | LBS | 100,000 | $1.68 | $0.00 | $1.68 | $168,000.00 | $1.68 | $0.00 | $1.68 | $168,000.00 | $1.68 | $0.00 | $1.68 | $168,000.00 | $1.68 | $0.00 | $1.68 | $168,000.00 |
| 0001AW | BEEF, COARSE GROUND, 81% LEAN, IMPS 136, U-26 (FROZEN). | Insert UPC Here | LBS | 400,000 | $1.15 | $0.00 | $1.15 | $460,000.00 | $1.15 | $0.00 | $1.15 | $460,000.00 | $1.15 | $0.00 | $1.15 | $460,000.00 | $1.15 | $0.00 | $1.15 | $460,000.00 |
| 0001AY | BEEF, COARSE GROUND, 93% LEAN, IMPS 136, U-23 (FROZEN). | Insert UPC Here | LBS | 750,000 | $1.74 | $0.00 | $1.74 | $1,305,000.00 | $1.74 | $0.00 | $1.74 | $1,305,000.00 | $1.74 | $0.00 | $1.74 | $1,305,000.00 | $1.74 | $0.00 | $1.74 | $1,305,000.00 |
| MANDATORY ITEMS FIXED PRICE (Fresh, Chilled) | MANDATORY ITEM STARTING WITH CLIN ENDING IN "AZ" (FIXED PRICE) | |||||||||||||||||||
| 0001AZ | BEEF HINDSHANK, NO IMPS. | Insert UPC Here | LBS | 49,000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 0001BA | SPECIAL BUYS - DO NOT PRICE (In Accordance with Addendum to FAR 52.212-4, Paragraph 14). | Insert UPC Here | ||||||||||||||||||
| ANNUAL TOTAL: | 7,956,000 | $19,609,490.00 | $19,609,490.00 | $19,609,490.00 | $19,609,490.00 | |||||||||||||||
| BASE PERIOD TOTAL (ANNUAL X 2) : | 15,912,000 | $39,218,980.00 | ||||||||||||||||||
| ADDITIONAL INFORMATION FOR IMPS 174, SHORTLOIN, SHORTCUT CLIN ENDING IN "AP" | ||||||||||||||||||||
| ANTERIOR END: Rib end shall be cut anterior to the 1st Lumbar vertebrae on a straight cut perpendicular to the fat side. | ||||||||||||||||||||
| POSTERIOR END: Sirloin end shall be cut posterior to the 5th Lumbar vertebrae on a straight cut perpendicular to the fat side. | ||||||||||||||||||||
| VENTRAL END: 0 x 1: 0 at the sirloin end to not more than 1" from the rib end. | ||||||||||||||||||||
| Block-Cut shortloins shall be cut square with not more than 3" tolerance on the anterior and posterior ends. |
&C&A&RPage &P of &N
Descriptions & Est Qty
| European Region Beef Requirements | EST ANNUAL QTY | |
| CLINS | PRIMALS AND SUB-PRIMALS | |
| 0001AA | BEEF RIB, RIB-EYE ROLL, LIP-ON, BONE-IN, WEIGHT 12-19 LBS; IMPS 109E, U-1. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | 80,000 |
| 0001AB | BEEF RIB, RIB-EYE ROLL, LIP-ON, BONELESS, HEAVY, WT RANGE 12-18 LBS; IMPS 112A, U-16. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | 500,000 |
| 0001AC | BEEF CHUCK SHOULDER CLOD, 2 PC (BLADE & ARM), WEIGHT 10-16 LBS; IMPS 114A, U81. | 640,000 |
| 0001AD | BEEF CHUCK ROLL, WEIGHT 15-23 LBS; IMPS 116A, U-80. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | 600,000 |
| 0001AE | BEEF CHUCK TENDERS, WEIGHT 2-4 LBS; IMPS 116B, U-36. Block-cut nose 1-3" thick. Block-cut tail 1-3" thick. | 400,000 |
| 0001AF | BEEF BRISKET, FLAT CUT, BONELESS, WEIGHT 5-9 LBS; IMPS 120A, U-82. | 100,000 |
| 0001AG | BEEF PLATE, INSIDE SKIRT (TRANSVERSUS ABDOMINOUS) SKINNED, WT RANGE 3-5 LBS; IMPS 121D, U-8. | 30,000 |
| 0001AH | BEEF SHORT PLATE, SHORT RIBS, TRIMMED, WT RANGE 3-5 LBS; IMPS 123A, U-9. | 42,000 |
| 0001AJ | BEEF ROUND, SHANK-OFF, PARTIALLY BONELESS, IMPS 161, U-11. | 49,000 |
| 0001AK | BEEF ROUND, KNUCKLE, PEELED, WT RANGE 8-12 LBS; IMPS 167A, U-12. Block-cut Patella end 1-3" thick, so it is perpendicular to bordering fat sides. | 525,000 |
| 0001AL | BEEF ROUND, TOP (INSIDE), DENUDED, WT RANGE 15-20 LBS; IMPS 169, U-90. | 1,500,000 |
| 0001AM | BEEF ROUND, OUTSIDE ROUNDS, WT RANGE 10-16 LBS; IMPS 171B, U-31. | 300,000 |
| 0001AN | BEEF ROUND, EYE OF ROUND, WT RANGE 3-7 LBS; IMPS 171C, U-15. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | 275,000 |
| 0001AP | BEEF LOIN, SHORT LOIN, SHORT-CUT, WT RANGE 15-23 LBS; IMPS 174, U-88. Block-cut. See bottom of spreadsheet for additional information. | 675,000 |
| 0001AQ | BEEF LOIN, STRIP LOIN, SHORT-CUT, BONELESS, WT RANGE 8-12 LBS; IMPS 180, U-87. Block-cut each end 1-3" thick, so ends are perpendicular to bordering fat sides. | 125,000 |
| 0001AR | BEEF LOIN, TOP SIRLOIN BUTT, 2 PC, BONELESS, WT RANGE 13-18 LBS, IMPS 184, U-89. | 625,000 |
| 0001AS | BEEF LOIN, TENDERLOIN, FULL, SIDE-MUSCLE ON, DEFATTED, LIGHT, WT RANGE 5 LBS AND UNDER, SELECT; IMPS 189A, U-20. | 14,000 |
| 0001AT | BEEF LOIN, TENDERLOIN BUTT, DEFATTED, WT RANGE 5 LBS AND UNDER, IMPS 191A, U-86. | 125,000 |
| 0001AU | BEEF FLANK, FLANK STEAK, WT RANGE 1-3 LBS; IMPS 193, U-21. | 95,000 |
| 0001AV | BEEF SPECIAL TRIM (CAP WEDGE AND PECTORAL), BONELESS, IMPS 139, U-35. | 100,000 |
| 0001AW | BEEF, COARSE GROUND, 81% LEAN, IMPS 136, U-26 (FROZEN). | 400,000 |
| 0001AY | BEEF, COARSE GROUND, 93% LEAN, IMPS 136, U-23 (FROZEN). | 750,000 |
| 0001AZ | BEEF HINDSHANK, NO IMPS. | 6,000 |
| 0001BA | SPECIAL BUYS - DO NOT PRICE (In Accordance with Addendum to FAR 52.212-4, Paragraph 14). | |
| 7,956,000 |
File details come from the government source that posted it. Updated .