4._Estimated_Institution_Usage.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Condiments, Individual Serving Packets (FAU25-89-13)
Solicitation number
0000035493
Issued by
California

About this file

This is an Excel spreadsheet detailing estimated annual usage of condiment products for various California state institutions, primarily focusing on correctional facilities, state hospitals, and veteran's homes across two geographic areas. The document outlines quarterly and monthly estimated delivery quantities for nine different condiment products, including French, Italian, Thousand Island, and Ranch dressings, catsup, mustard, mayonnaise, sweet pickle relish, and mild taco sauce. The estimated annual quantities are substantial, with a grand total ranging from 2,586 to 14,124 cases across different product types, serving institutions such as Soledad High Desert State Prison, Corcoran Prison, San Quentin Prison, and Yountville Veteran's Home.

The spreadsheet provides a comprehensive breakdown of projected condiment needs, organized by Area 1 and Area 2, with specific quarterly or monthly delivery schedules for each institution. The estimated usage varies significantly between facilities, with some requiring weekly deliveries (like Yountville Veteran's Home) and others on a quarterly basis. The document appears to be part of a state procurement process, likely for a multi-year contract to supply condiment packets to California state institutions, with total annual requirements across both areas reaching up to 14,124 cases for some product types. The detailed nature of the spreadsheet suggests a structured approach to institutional food service supply chain management, focusing on precise quantity forecasting and consistent product distribution across a wide network of state facilities.

View the file

Other files

File Type Posted
00._FAU_APP_Front_Page.docx DOCX document
1._Pricing_Worksheet_0000035493.xlsx XLSX spreadsheet
3._Narrative_Response_0000035493.docx DOCX document
0._IFB_0000035493.docx DOCX document
5._Food_Safety_Information_Listing.docx DOCX document
6._Northern-Southern_Institution_Listing.docx DOCX document
2._8950-BS-0252793.pdf PDF

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

Sheet1

Attachment 4 - Estimated Usage
Commodity:Condiments, Individual Serving Packets
Event ID:0000035493
Area 1Annual Quantities (cases)
ESTIMATED DELIVERIES SCHEDULE:Dressing, French (500/cs)Dressing, Italian (500/cs)Dressing, Thousand Island (500/cs)Dressing, Ranch (500/cs)Catsup (1000/cs)Mustard (1000/cs)Mayonnaise (500/cs)Relish, Pickle, Sweet (500/cs)Taco Sauce, Mild (500/cs)
INSTITUTIONS
Blind/Deaf School Fremont
CA Medical FacilityQUARTERLY15046435015016820116450
Central CA Womens FacilityQUARTERLY200693330133
CHCF - StocktonQUARTERLY2563258081278625126
CSP - Sacramento (Folsom)QUARTERLY667705610684634255042661,164
CTF/Soledad
High Desert State PrisonMONTHLY4008008003001,160960400760540
Highway Patrol AcademyQUARTERLY
Lassen Camp Warehouse
Mule Creek PrisonQUARTERLY1001,384748555210301801,045
Napa State Hospital
North Coast Warehouse
Pelican Bay Prison
R.A. McgeeQUARTERLY
Salinas Valley PrisonQUARTERLY400600334126324156120156640
San Quentin PrisonQUARTERLY520520520312156
Sierra Conservation CenterQUARTERLY350300350150250160180150460
Solano PrisonQUARTERLY6005001004502001001,000
Valley State PrisonQUARTERLY340410276198397123130370
Yountville Veteran's HomeWEEKLY242424365050604030

Total Area 1 2,456 6,070 4,537 2,344 4,450 2,350 880 1,953 5,958

Area 2Annual Quantities (cases)
DELIVERIES SCHEDULE:Dressing, French (500/cs)Dressing, Italian (500/cs)Dressing, Thousand Island (500/cs)Dressing, Ranch (500/cs)Catsup (1000/cs)Mustard (1000/cs)Mayonnaise (500/cs)Relish, Pickle, Sweet (500/cs)Taco Sauce, Mild (500/cs)
INSTITUTIONS
Atascadero State HospitalQUARTERLY481525010020040005300
Avenal PrisonQUARTERLY4001,000400100400160200800
CA Corr. Instit./TehachapiQUARTERLY670600350175180415
CA Institute for MenQUARTERLY200200200250120120300
CA Institute for WomenQUARTERLY801601601601401008080160
CA Mens ColonyQUARTERLY246274246246061204496
CA Rehabilitation CenterMONTHLY9050025025020030025050500
Calipatria PrisonQUARTERLY360400320320320240140480
Centinela PrisonQUARTERLY1,0401,04030093620220
Chuckawalla Prison
Coalinga State Hospital
Corcoran PrisonMONTHLY480462492433257561240122541
CSATF/Corcoran IIQUARTERLY5861,230630714728396308528
Deaf/Riverside
Ironwood PrisonQUARTERLY400560560360188160480
Kern Valley State PrisonQUARTERLY1,00044020080800
L.A. County Prison
Metropolitan State HospitalQUARTERLY100100100200400100400300
North Kern PrisonQUARTERLY87204160
Patton State HospitalQUARTERLY131684872
Pleasant Valley PrisonMONTHLY20055055075350150150500
Porterville Developmental Center
R.J. Donovan
South Camp WarehouseQUARTERLY50100
Wasco PrisonQUARTERLY2020500175200810

Total Area 2 2,555 8,054 5,563 3,528 5,350 4,105 1,706 2,019 7,642

GRAND TOTAL of 1 & 2 5,011 14,124 10,100 5,872 9,800 6,455 2,586 3,972 13,600 end of sheet

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