Bread ordering.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- Bread FY25 2nd Quarter Federal contract opportunity
- Solicitation number
- 15B51625Q00000004
- Issued by
- Department of Justice Bureau of Prisons
About this file
This is an Excel spreadsheet detailing bread product requirements and inventory calculations for what appears to be a correctional facility meal service. The document breaks down weekly menu requirements across a 5-week cycle for hamburger buns, hot dog buns, and sliced bread, with base count of 1,100 meals. The calculations include racks needed, bags per rack, buns per bag, and total individual pieces needed per quarter. Total quarterly requirements are: 33,300 hamburger buns (1,110 bags), 29,808 hot dog buns (552 bags), and 594,440 slices of bread (10,340 bags).
The associated solicitation (15B51625Q00000004) is for bread products for FY25 2nd Quarter at the Federal Correctional Institution Three Rivers, Texas. Quotes are due by 10:00 am CST on December 13, 2024, with anticipated award date of December 29, 2024. All deliveries must be F.O.B. Destination. Quotes must be submitted via email to TRV-ProcurementProp-S@bop.gov, with Walter Soto-Ruiz serving as the Contracting Officer.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Synopsis 2nd Quarter Bread.pdf | ||
| 15B51625Q00000004 FS Bread.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| INVENTORY (RACKS) | MEALS AVAILABLE | VARIABLES | WEEKLY MENU REPEATS | |||
| W1 | 2 | |||||
| BASE COUNT | 1100 | W2 | 2 | |||
| HAMBURGER | 10 | 0.55 | HB SERV/RACK | 60 | W3 | 3 |
| HOT DOG | 0 | 0.00 | HD SERV/RACK | 60 | W4 | 3 |
| SLICED BREAD | 0 | 0.00 | SLICED SERV/RACK | 80 | W5 | 3 |
WEEK 1 MEALS RACKS NEEDED BAGS X RACK BUNS X BAG BAGS NEEDED IND PIECE NEEDED X QTR
| HAMBURGER | 2.00 | 37 | 5 | 12 | 185 | 2220 | 4440 |
| HOT DOG | 0.00 | 0 | 0 | 0 | 0 | ||
| SLICED BREAD | 15.00 | 207 | 10 | 22 | 2070 | 45540 | 91080 |
WEEK 2 MEALS RACKS NEEDED BAGS X RACK BUNS X BAG BAGS NEEDED IND PIECE NEEDED X QTR
| HAMBURGER | 4.00 | 74 | 5 | 12 | 370 | 4440 | 8880 |
| HOT DOG | 0.00 | 0 | 0 | 0 | 0 | ||
| SLICED BREAD | 14.00 | 193 | 10 | 22 | 1930 | 42460 | 84920 |
WEEK 3 MEALS RACKS NEEDED BAGS X RACK BUNS X BAG BAGS NEEDED IND PIECE NEEDED X QTR
| HAMBURGER | 2.00 | 37 | 5 | 12 | 185 | 2220 | 6660 |
| HOT DOG | 0.00 | 0 | 0 | 0 | 0 | ||
| SLICED BREAD | 16.00 | 220 | 10 | 22 | 2200 | 48400 | 145200 |
WEEK 4 MEALS RACKS NEEDED BAGS X RACK BUNS X BAG BAGS NEEDED IND PIECE NEEDED X QTR
| HAMBURGER | 2.00 | 37 | 5 | 12 | 185 | 2220 | 6660 |
| HOT DOG | 2.00 | 37 | 6 | 18 | 222 | 3996 | 11988 |
| SLICED BREAD | 15.00 | 207 | 10 | 22 | 2070 | 45540 | 136620 |
WEEK 5 MEALS RACKS NEEDED BAGS X RACK BUNS X BAG BAGS NEEDED IND PIECE NEEDED X QTR
| HAMBURGER | 2.00 | 37 | 5 | 12 | 185 | 2220 | 6660 |
| HOT DOG | 3.00 | 55 | 6 | 18 | 330 | 5940 | 17820 |
| SLICED BREAD | 15.00 | 207 | 10 | 22 | 2070 | 45540 | 136620 |
| TOTAL | BAGS TOTAL | EACH TOTAL | PER QTR TOTAL | ||
| EACH | BAGS | RACKS | |||
| HAMBURGER | 1110 | 13320 | 33300 | 2775 | 555 |
| HOT DOG | 552 | 9936 | 29808 | 1656 | 276 |
| SLICED BREAD | 10340 | 227480 | 594440 | 27020 | 2702 |
File details come from the government source that posted it. Updated .