4._Estimated_Institution_Usage.xlsx
XLSX spreadsheet 22 KB Posted
- 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 |
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 1 | Annual 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 Facility | QUARTERLY | 150 | 464 | 350 | 150 | 168 | 20 | 116 | 450 | |
| Central CA Womens Facility | QUARTERLY | 200 | 69 | 33 | 30 | 133 | ||||
| CHCF - Stockton | QUARTERLY | 25 | 63 | 25 | 80 | 81 | 27 | 86 | 25 | 126 |
| CSP - Sacramento (Folsom) | QUARTERLY | 667 | 705 | 610 | 684 | 634 | 255 | 04 | 266 | 1,164 |
| CTF/Soledad | ||||||||||
| High Desert State Prison | MONTHLY | 400 | 800 | 800 | 300 | 1,160 | 960 | 400 | 760 | 540 |
| Highway Patrol Academy | QUARTERLY | |||||||||
| Lassen Camp Warehouse | ||||||||||
| Mule Creek Prison | QUARTERLY | 100 | 1,384 | 748 | 555 | 210 | 30 | 180 | 1,045 | |
| Napa State Hospital | ||||||||||
| North Coast Warehouse | ||||||||||
| Pelican Bay Prison | ||||||||||
| R.A. Mcgee | QUARTERLY | |||||||||
| Salinas Valley Prison | QUARTERLY | 400 | 600 | 334 | 126 | 324 | 156 | 120 | 156 | 640 |
| San Quentin Prison | QUARTERLY | 520 | 520 | 520 | 312 | 156 | ||||
| Sierra Conservation Center | QUARTERLY | 350 | 300 | 350 | 150 | 250 | 160 | 180 | 150 | 460 |
| Solano Prison | QUARTERLY | 600 | 500 | 100 | 450 | 200 | 100 | 1,000 | ||
| Valley State Prison | QUARTERLY | 340 | 410 | 276 | 198 | 397 | 123 | 130 | 370 | |
| Yountville Veteran's Home | WEEKLY | 24 | 24 | 24 | 36 | 50 | 50 | 60 | 40 | 30 |
Total Area 1 2,456 6,070 4,537 2,344 4,450 2,350 880 1,953 5,958
| Area 2 | Annual 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 Hospital | QUARTERLY | 48 | 15 | 250 | 100 | 200 | 400 | 05 | 300 | |
| Avenal Prison | QUARTERLY | 400 | 1,000 | 400 | 100 | 400 | 160 | 200 | 800 | |
| CA Corr. Instit./Tehachapi | QUARTERLY | 670 | 600 | 350 | 175 | 180 | 415 | |||
| CA Institute for Men | QUARTERLY | 200 | 200 | 200 | 250 | 120 | 120 | 300 | ||
| CA Institute for Women | QUARTERLY | 80 | 160 | 160 | 160 | 140 | 100 | 80 | 80 | 160 |
| CA Mens Colony | QUARTERLY | 246 | 274 | 246 | 246 | 06 | 12 | 04 | 496 | |
| CA Rehabilitation Center | MONTHLY | 90 | 500 | 250 | 250 | 200 | 300 | 250 | 50 | 500 |
| Calipatria Prison | QUARTERLY | 360 | 400 | 320 | 320 | 320 | 240 | 140 | 480 | |
| Centinela Prison | QUARTERLY | 1,040 | 1,040 | 300 | 936 | 20 | 220 | |||
| Chuckawalla Prison | ||||||||||
| Coalinga State Hospital | ||||||||||
| Corcoran Prison | MONTHLY | 480 | 462 | 492 | 433 | 257 | 561 | 240 | 122 | 541 |
| CSATF/Corcoran II | QUARTERLY | 586 | 1,230 | 630 | 714 | 728 | 396 | 308 | 528 | |
| Deaf/Riverside | ||||||||||
| Ironwood Prison | QUARTERLY | 400 | 560 | 560 | 360 | 188 | 160 | 480 | ||
| Kern Valley State Prison | QUARTERLY | 1,000 | 440 | 200 | 80 | 800 | ||||
| L.A. County Prison | ||||||||||
| Metropolitan State Hospital | QUARTERLY | 100 | 100 | 100 | 200 | 400 | 100 | 400 | 300 | |
| North Kern Prison | QUARTERLY | 87 | 204 | 160 | ||||||
| Patton State Hospital | QUARTERLY | 13 | 168 | 48 | 72 | |||||
| Pleasant Valley Prison | MONTHLY | 200 | 550 | 550 | 75 | 350 | 150 | 150 | 500 | |
| Porterville Developmental Center | ||||||||||
| R.J. Donovan | ||||||||||
| South Camp Warehouse | QUARTERLY | 50 | 100 | |||||||
| Wasco Prison | QUARTERLY | 20 | 20 | 500 | 175 | 200 | 810 |
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 .