Attachment 1- Schedule of Items Illnois.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- SPE300-24-R-0029
About this file
This is a pricing spreadsheet template for solicitation SPE300-24-R-0029 covering fresh fruit and vegetables for Illinois Zone customers, divided into two groups: Troops (Group 1) and Schools (Group 2). The spreadsheet requires vendors to provide delivered pricing and distribution pricing across three tiers (24-month base period plus two 18-month option periods) for 31 produce items for Troops and 50 items for Schools.
The template lists detailed product specifications and estimated quantities for items including apples, bananas, broccoli, lettuce, tomatoes and other fresh produce. For Troops, the total 24-month estimated quantity is 10,365 cases. For Schools, the estimated quantity is much larger at 1,682,402 cases. Vendors must complete pricing for all line items and tiers, with separate columns for delivered pricing including freight and distribution pricing. The spreadsheet includes automatic calculations for total evaluated price incorporating weighted distribution pricing factors.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 5 - QSMV and Quality Audits.pdf | ||
| Attachment 4 - Stores and FFAVORS Manuals.pdf | ||
| Attachment 2 - Request for New Item.pdf | ||
| Attachment 3 - Troop and School Customers IL.xlsx | XLSX spreadsheet |
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
Troops
| SOLICITATION: SPE300-24-R-0029 Illinois Troops (Group 1) 24 MONTH ESTIMATES -- (31) ITEMS | |||||||||||||
| Vendor Name & Cage Code: | |||||||||||||
| DO NOT TOUCH THE SHADED FIELDS!!! ONLY FILL IN WHITE FIELDS!! BID ON ALL ITEMS!!! FILL OUT CELLS (H7, M7 & N7) SAVE TO A CD!! | |||||||||||||
| IF YOU ARE REQUESTED TO SUBMIT AN INVOICE, PLEASE LABEL INVOICES WITH GOV'T ITEM # NEXT TO ITEM | Please fill out Tier 2 Distribution Price | Please fill out Tier 3 Distribution Price | |||||||||||
| GOV'T | GOV'T | AVG Gov | Gov't Item | EST | Unit of | Delivered Pricing | Tier 1 Distribution | Unit | Total Delivered | Total (DIP) | Total Evaluated | Tier 2 Distribution | Tier 3 Distribution |
| Item # | ITEM CD | Cs Wt | Description | quantity | Issue | Including Freight | (DIP) Price | Price | Price (DEP) | Price | Price | DIP Price | DIP Price |
| 1 | 891501E210797 | 40 | APPLE - GALA 125/138 CT | 108 | CS | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 2 | 891501E210016 | 40 | BANANAS, FRESH, GREENISH-YELLOW, #4, 40 LB CS | 164 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 3 | 891501E210021 | 12 | BROCCOLI FLORETS, CHL, US#1, 4/3 LB BG | 582 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 4 | 891501E210054 | 25 | CARROTS, FRESH, WHL, TOPPED, JUMBO, US#1, 1/25 LB CS | 374 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 5 | 891501E210540 | 12 | CAULIFLORETS, CHL, US#1, ICELESS, 4/3 LB PG | 404 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 6 | 891501E210504 | 10 | CELERY - 6 COUNT CS | 290 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 7 | 891501E214832 | 1 | CILANTRO, FRESH, 6 ct pg | 282 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 8 | 891501E210074 | 20 | CUCUMBERS, FRESH, SUPER SEL, US#1, 1/20 LB CS | 288 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 9 | 891501E212029 | 18 | GRAPES, FRESH, red, sdls, US#1 Table, 18 lb cs | 246 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 10 | 891501E210355 | 25 | HONEYDEW MELON, FRESH, US#1, 6 CT, 1/25 LB CS | 358 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 11 | 891501E214628 | 2 | LEMONS, FRESH, US#1, 12 CT, 2 LB CS | 110 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 12 | 891501E210891 | 12 | LETTUCE - ROMAINE CH 6/2 LB CS | 654 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 13 | 891501E210344 | 35 | LETTUCE, FRESH, iceberg, US#1, 24 ct, 35 lb cs | 360 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 14 | 891501E210357 | 10 | MUSHROOMS, FRESH, US#1, 1/10 LB CS | 230 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 15 | 891501E210537 | 18 | ONIONS, GREEN, FRESH, US#1, ICELESS, 1/8 LB CS | 310 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 16 | 891501E210362 | 50 | ONIONS, YELLOW, DRY, 2 IN. RD, US#1, 1/50 LB CS | 290 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 17 | 891501E210369 | 35 | ORANGES, FRESH, any, no temple, US#1, 88 ct, 35 lb cs | 118 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 18 | 891501E212074 | 1.5 | PARSLEY, FRESH, 6 ct, 1.5 lb cs | 230 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 19 | 891501E210381 | 8 | PEPPERS - GREEN BEL 1 1/8 BUSH | 230 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 20 | 891501E210195 | 5 | PEPPERS, FRESH, swt, red, US#1, 5 lb cs | 702 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 21 | 891501E210883 | 20 | PINEAPPLE, FRESH, 5-7 CT, 1/20 LB CS | 256 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 22 | 891501E210391 | 50 | POTATOES, FRESH, baking, US#1, 70 ct, 50 lb cs | 434 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 23 | 891501E211274 | 10 | POTATOES, FRESH, red, size B, 10 lb cs | 658 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 24 | 891501E211259 | 3 | SALAD MIX, CHL, SPRING MIX, 1/3 LB CS | 214 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 25 | 891501E210248 | 20 | SALAD MX CHL 4/5 LB BG | 198 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 26 | 891501E210707 | 10 | SPINACH, FRESH, LEAF, US#1, 4/2.5 LB BGS | 274 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 27 | 891501E210906 | 5 | SQUASH, FRESH, green, zucchini, 5 lb cs | 703 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 28 | 891501E210904 | 5 | SQUASH, FRESH, yellow, 5 lb cs | 462 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 29 | 891501E210262 | 8 | STRAWBERRIES, FRESH, US#1, QT SZ CO, 1/8 LB CS | 266 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 30 | 891501E210501 | 25 | TOMATOES, FRESH, PINK, US#1, MIN 2 IN. RD, 1/25 LB CS | 412 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 31 | 891501E212126 | 9 | TOMATOES, GRAPE, FRESH, 1/9 LB CS | 158 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 24 Month Est Qty | 10,365 | TIER 1 EVALUATION (24 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||
| TIER 2 EVALUATION (18 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||||
| TIER 3 EVALUATION (18 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||||
| TOTAL EVALUATION INCLUDING TIERS (UNWEIGHTED) | $0.00 | $0.00 | $0.00 | ||||||||||
| TOTAL EVALUATION INCLUDING TIERS (WEIGHTED) | $0.00 | $0.00 | $0.00 |
Schools
| SOLICITATION: SPE300-24-R-0029 Ilinois SCHOOLS (Group 2) 24 MONTH ESTIMATES -- (50) ITEMS | |||||||||||||
| Vendor Name & Cage Code: | |||||||||||||
| DO NOT TOUCH THE SHADED FIELDS!!! ONLY FILL IN WHITE FIELDS!! BID ON ALL ITEMS!!! FILL OUT CELLS (H7,M7, & N7) SAVE TO A CD!! | |||||||||||||
| IF YOU ARE REQUESTED TO SUBMIT AN INVOICE, PLEASE LABEL INVOICES WITH GOV'T ITEM # NEXT TO ITEM | Please fill out Tier 2 Distribution Price | Please fill out Tier 3 Distribution Price | |||||||||||
| GOV'T | GOV'T | AVG Gov | Gov't Item | EST | Unit of | Delivered Pricing | Tier 1 Distribution | Unit | Total Delivered | Total (DIP) | Total Evaluated | Tier 2 Distribution | Tier 3 Distribution |
| Item # | ITEM CD | Cs Wt | Description | quantity | Issue | Including Freight | (DIP) Price | Price | Price (DEP) | Price | Price | DIP Price | DIP Price |
| 1 | 891501E050354 | 40 | APPLES FR R/D 125-138 CT 40 LB CS | 255,593 | CS | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| 2 | 891501E050334 | 40 | APPLES FR ROYAL GALA 125-150 CT 40 LB CS | 174,309 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 3 | 891501E051287 | 3 | BROCCOLI FLORETS CHL 3 LB BG | 6,364 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 4 | 891501E050388 | 12 | BROCCOLI FLORETS CHL 4/3 LB BG | 51,190 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 5 | 891501E051278 | 50 | CABBAGE FR GRN FOR PR 50 LB BG | 322 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 6 | 891501E050374 | 20 | CABBAGE W/CARROTS CHL GRN SHRD 4/5 LB BG | 10,554 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 7 | 891501E050090 | 5 | CARROT CHL SHRD 1/5 LB PG | 14,492 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 8 | 891501E052164 | 30 | CARROTS CHL BABY WHL 30/1 LB BG | 98,826 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 9 | 891501E050376 | 20 | CARROTS CHL BABY WHL 4/5 LB PG | 98,808 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 10 | 891501E050303 | 3 | CAULIFLORETS CHL 1/3 LB BG | 6,632 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 11 | 891501E050392 | 20 | CAULIFLOWER FR 9-12 CT 20 LB CS | 4,568 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 12 | 891501E050465 | 20 | CELERY CHL STICKS 4/5 LB BG | 54,126 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 13 | 891501E051188 | 5 | CELERY CHL STICKS 5 LB CS | 13,480 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 14 | 891501E050854 | 30 | CLEMENTINES FR 30 LB CS | 42,674 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 15 | 891501E051071 | 25 | CORN FRESH WHL US#1 48 CT 25 LB CS | 1,052 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 16 | 891501E051164 | 17 | CUCUMBERS FR US#1, 24 CT 17 LB CS | 24,456 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 17 | 891501E052149 | 38 | GRAPEFRUIT FR 40 CT 38 LB CS | 2,224 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 18 | 891501E050124 | 18 | GRAPES GRN/WHT SDLS US#1, 18 LB CS | 13,674 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 19 | 891501E050708 | 6 | GRAPES RED SDLS 50/2 OZ PG 6 LB CS | 53,970 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 20 | 891501E050123 | 18 | GRAPES RED SDLS US#1 1/18 LB CS | 21,688 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 21 | 891501E050180 | 5 | JICAMA, CHL, STICKS, 5 LB BG | 3,994 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 22 | 891501E051028 | 12 | LETTUCE CHL ROMAINE CHOP 6/2 LB BG | 31,052 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 23 | 891501E051963 | 12 | LETTUCE CHL ROMAINE SHRD 6/2 LB | 22,428 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 24 | 891501E051292 | 20 | LETTUCE CHL SHRD 4/5 LB BG | 1,722 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 25 | 891501E050606 | 20 | LETTUCE CHL SHRD 4/5 LB BG | 6,098 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 26 | 891501E052073 | 40 | LETTUCE FR ICEBERG 24 CT 40 LB CS | 468 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 27 | 891501E050369 | 20 | LETTUCE FR LEAF GREEN 24 CT 20 LB CS | 1,020 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 28 | 891501E050054 | 35 | LETTUCE FR ROMAINE US#1, 24 CT 35 LB CS | 6,754 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 29 | 891501E051605 | 5 | ONION, RED, FRESH, 5 LB CASE | 5,192 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 30 | 891501E050413 | 25 | ONIONS RED DRY JUMBO 25 LB CS | 1,058 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 31 | 891501E051630 | 5 | ONIONS YEL DRY 5 LB BG | 4,424 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 32 | 891501E050405 | 50 | ONIONS YEL DRY JUMBO 50 LB CS | 3,884 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 33 | 891501E052047 | 12.5 | ORANGES CHL WEDGES 50/4 OZ PG, 12.5 LB C | 40,386 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 34 | 891501E050209 | 40 | ORANGES FR 113-125 CT 40 LB CS | 135,480 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 35 | 891501E050210 | 35 | ORANGES FR 138 CT 35 LB CS | 18,916 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 36 | 891501E051631 | 40 | PEARS FR 90-150 CT 40 LB CS | 102,238 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 37 | 891501E050678 | 50 | POTATO BAKING FR 70 CT 50 LB CS | 4,322 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 38 | 891501E050033 | 50 | POTATO BAKING USX#1/#1 100-110 CT1/50 LB | 7,728 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 39 | 891501E050605 | 20 | SALAD MIX CHL 4/5 LB BG | 15,600 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 40 | 891501E051025 | 20 | SALAD MIX CHL ROMAINE BLEND 4/5 LB BG | 6,444 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 41 | 891501E051026 | 3 | SALAD MIX CHL SPRING MIX 3 LB BG/CS | 21,078 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 42 | 891501E051346 | 10 | SPINACH CHL CLEAN & TRIM 4/2.5 LB PG | 9,670 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 43 | 891501E050487 | 20 | SQUASH YELLOW FR 20 LB CS | 5,420 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 44 | 891501E051342 | 20 | SQUASH ZUCCHINI FR 20 LB CS | 18,472 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 45 | 891501E050971 | 8 | STRAWBERRIES FR CLAMSHELL 8/1 LB CO | 24,320 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 46 | 891501E050066 | 5 | TOMATO CHL DICE FOR TACOS 1/ 5 LB BG | 8,488 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 47 | 891501E051204 | 10 | TOMATO GRAPE 12/1 PT CO 10 LB CS | 55,552 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 48 | 891501E051873 | 10 | TOMATOES CHL SL 2/5 LB BG | 3,158 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 49 | 891501E051237 | 25 | TOMATOES FR 6X6, 25 LB CS | 36,522 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 50 | 891501E051286 | 5 | WATERMELON CHL CHUNKS 1/5 LB BG | 131,512 | CS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Leave Blank | Leave Blank | |
| 24 Month Est Qty | 1,682,402 | TIER 1 EVALUATION (24 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||
| TIER 2 EVALUATION (18 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||||
| TIER 3 EVAULATION (18 MONTH) | $0.00 | $0.00 | $0.00 | ||||||||||
| TOTAL EVALUATION INCLUDING TIERS (UNWEIGHTED) | $0.00 | $0.00 | $0.00 | ||||||||||
| TOTAL EVALUATION INCLUDING TIERS (WEIGHTED) | $0.00 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .