Attachment I - Food Center WIC Formula Purchases 3-year Trend.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- IFB Infant Formula Rebate Program
- Solicitation number
- 22-444DHS-FAMCO-B-28401
- Issued by
- Illinois
About this file
This document is an attachment to a state and local contract opportunity issued by the Illinois Department of Human Services for its WIC (Women, Infants, and Children) infant formula rebate program. The contract seeks infant formula manufacturers to supply and provide a rebate on all infant formulas the state chooses to issue, except for exempt infant formulas, for a 3-year period. The attachment provides a 3-year historical trend of infant formula purchases by the state for this program, including product details, quantities, and spend amounts. Key products include Enfamil, Similac, Neocate, EleCare, and PediaSure, among others, with total purchases of over 150,000 cases and 1.06 million units in the most recent year.
The contract opportunity appears to be an Invitation for Bid (IFB) process, though specific submission requirements and deadlines are not included in this document. Pricing terms, set-asides, and other salient contractual details are also not provided. The historical purchasing data indicates the state's current formula needs and spending levels to inform prospective bidders on the scope and scale of the opportunity.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Questions and Answers for B-28401~1.pdf | ||
| Forms A~44.docx | DOCX document | |
| Attachment F-1 - FFY22 Rebate Receipts.pdf | ||
| Attachment C - WIC Food Center Information.docx | DOCX document | |
| Attachment H - Active Vendors February 2022.xlsx | XLSX spreadsheet | |
| Attachment B - Food Center Addresses.xlsx | XLSX spreadsheet | |
| Attachment G - Infant Formula Invoices 2021-2022.pdf | ||
| B-28401 Notice of Award Form v.22.1_41.pdf | ||
| Forms B~60.docx | DOCX document | |
| Attachment A - Federal Participation.docx | DOCX document | |
| Notice of Electronic Submission Only v.22.1~39.pdf | ||
| Attachment E-2 - 11 months non-Rebate Formula redemptions 2021-2022.pdf | ||
| Attachment D - 2023 Rebate Bid Sheet~1.xlsx | XLSX spreadsheet | |
| Attachment F-3 - FFY20 Rebate Receipts.pdf | ||
| Attachment F-2 - FFY21 Rebate Receipts.pdf | ||
| Attachment E-1 - 11 months Rebate Formula redemptions 2021-2022.pdf | ||
| DHS IFB WIC Infant Formula-B-28401.docx | DOCX document |
Show all 17
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
Formula Purchases
ATTACHMENT I - FOOD CENTER PROJECT WIC WAREHOUSE INFANT FORMULA PURCHASES
| 07/01/18 to 06/30/19 | Case Packs | Cases | Units | 07/01/19 to 06/30/20 | Case Packs | Cases | Units | 07/01/20 to 06/30/21 | Case Packs | Cases | Units |
| MSS/Nutricia | 418 | MSS/Nutricia | 503 | MSS/Nutricia | 689 | ||||||
| Neocate EO28 Splash Orange-Pineapple | 27 | 120 | 3,240 | Neocate EO28 Splash Orange-Pineapple | 27 | 83 | 2,241 | Neocate EO28 Splash Orange-Pineapple | 27 | 149 | 4,023 |
| Neocate Junior 14 o.z. | 4 | 66 | 264 | Neocate Junior 14 o.z. | 4 | 60 | 240 | Neocate E028 Splash Tropical | 27 | 15 | 405 |
| Neocate Syneo Infant | 4 | 72 | 288 | Neocate Syneo Infant | 4 | 15 | 60 | Neocate EO28 Splash UnFlavored | 27 | 39 | 1,053 |
| Neocate W/DHA & ARA Powder | 4 | 160 | 640 | Neocate W/DHA & ARA Powder | 4 | 345 | 1,380 | Neocate Junior 14 o.z. | 4 | 375 | 1,500 |
| Neocate Junior Chocolate Powder | 4 | 27 | 108 | ||||||||
| Mead Johnson | 133,406 | Mead Johnson | 106,109 | Neocate Junior Strawberry Powder | 4 | 4 | 16 | ||||
| EnfaCare RTU 8oz. | 4 | 705 | 2,820 | Enfamil A.R. RTU 8oz. | 4 | 20 | 80 | Neocate Syneo Infant | 4 | 18 | 72 |
| Enfamil A.R. RTU 8oz. | 4 | 60 | 240 | Enfamil Gentlease Pwd | 6 | 31676 | 190,056 | Neocate W/DHA & ARA Powder | 4 | 62 | 248 |
| Enfamil Gentlease Pwd | 6 | 33,423 | 200,538 | Enfamil Infant AR Pwdr | 6 | 5182 | 31,092 | ||||
| Enfamil Infant AR Pwdr | 6 | 5,472 | 32,832 | Enfamil Infant Conc. Liq | 12 | 6120 | 73,440 | Mead Johnson | 42,416 | ||
| Enfamil Infant Conc. Liq | 12 | 6,460 | 77,520 | Enfamil Infant Pwd WIC | 6 | 59520 | 357,120 | Enfamil Gentlease Pwd | 6 | 15987 | 95,922 |
| Enfamil Infant Pwd WIC | 6 | 84,510 | 507,060 | Enfamil Infant RTU 32oz. | 6 | 200 | 1,200 | Enfamil Infant AR Pwdr | 6 | 1476 | 8,856 |
| Enfamil Infant RTU 32oz. | 6 | 120 | 720 | Enfamil NeuroPro EnfaCare Pwd. 12.8oz | 6 | 1359 | 8,154 | Enfamil Infant Conc. Liq | 12 | 3018 | 36,216 |
| Enfamil NeuroPro EnfaCare Pwd. 12.8oz | 6 | 1,792 | 10,752 | Enfamil NeuroPro Infant RTU 32oz. | 4 | 450 | 1,800 | Enfamil Infant Pwd WIC | 6 | 19791 | 118,746 |
| Enfamil ProSobee RTU 8oz. | 4 | 25 | 100 | Enfamil ProSobee RTU 8oz. | 4 | 8 | 32 | Enfamil Infant RTU 32oz. | 6 | 191 | 1,146 |
| Enfamil Reguline Powder | 6 | 471 | 2,826 | Enfamil Reguline Powder | 6 | 1328 | 7,968 | Enfamil NeuroPro EnfaCare Pwd. 12.8oz | 6 | 1135 | 6,810 |
| Pregestamil Powder | 6 | 32 | 192 | Pregestamil Powder | 6 | 32 | 192 | Enfamil ProSobee RTU 32oz | 4 | 65 | 260 |
| ProSobee Liq WIC | 12 | 306 | 3,672 | ProSobee Liq WIC | 12 | 170 | 2,040 | Enfamil Reguline Powder | 6 | 458 | 2,748 |
| PURAMINO (DHA & ARA) Powder | 4 | 30 | 120 | PURAMINO (DHA & ARA) Powder | 4 | 44 | 176 | Pregestamil Powder | 6 | 49 | 294 |
| ProSobee Liq WIC | 12 | 42 | 504 | ||||||||
| Nestles USA | 70 | Nestles USA | 8 | ProSobee Pwd WIC | 6 | 133 | 798 | ||||
| Nutren Jr. w/Fiber | 24 | 28 | 672 | Nutren Jr. w/Fiber | 24 | 8 | 192 | PURAMINO (DHA & ARA) Powder | 4 | 71 | 284 |
| Peptamen Junior W/Fiber | 24 | 25 | 600 | ||||||||
| Nutren Junior Liquid Vanilla | 24 | 17 | 408 | Ross Laboratories | 16,547 | Nestles USA | 35 | ||||
| Alimentum Adv Iron 32oz | 6 | 275 | 1,650 | Nutren Jr. w/Fiber | 24 | 25 | 600 | ||||
| Ross Laboratories | 16,490 | Alimentum w/DHA-E & Protein | 6 | 1424 | 8,544 | Peptamen Junior W/Fiber | 24 | 5 | 120 | ||
| Alimentum Adv Iron 32oz | 6 | 430 | 2,580 | EleCare for Infants | 6 | 288 | 1,728 | Nutren Junior Liquid Vanilla | 24 | 5 | 120 |
| Alimentum w/DHA-E & Protein | 6 | 912 | 5,472 | EleCare Junior (Banana) | 6 | 14 | 84 | ||||
| EleCare for Infants | 6 | 224 | 1,344 | EleCare Junior (Unflavored) | 6 | 93 | 558 | Ross Laboratories | 9,314 | ||
| EleCare Junior (Unflavored) | 6 | 62 | 372 | EleCare Junior (Vanilla) | 6 | 117 | 702 | Alimentum Adv Iron 32oz | 6 | 94 | 564 |
| EleCare Junior (Vanilla) | 6 | 128 | 768 | NeoSure new | 6 | 6190 | 37,140 | Alimentum w/DHA-E & Protein | 6 | 633 | 3,798 |
| NeoSure new | 6 | 6,617 | 39,702 | PediaSure (Vanilla) 1.5 CAL 8oz | 24 | 207 | 4,968 | EleCare for Infants | 6 | 249 | 1,494 |
| PediaSure (Vanilla) 1.5 CAL 8oz | 24 | 307 | 7,368 | Pediasure Peptide (Strawberry) | 24 | 110 | 2,640 | EleCare Junior (Banana) | 6 | 39 | 234 |
| Pediasure Peptide (Strawberry) | 24 | 110 | 2,640 | PediaSure Peptide (Vanilla) | 24 | 448 | 10,752 | EleCare Junior (Unflavored) | 6 | 207 | 1,242 |
| PediaSure Peptide (Vanilla) | 24 | 455 | 10,920 | Pediasure Strawberry Btl. | 24 | 936 | 22,464 | EleCare Junior (Vanilla) | 6 | 238 | 1,428 |
| Pediasure Strawberry Btl. | 24 | 1,404 | 33,696 | Pediasure Vanilla Btl. | 24 | 1287 | 30,888 | Ensure Plus Vanilla | 24 | 38 | 912 |
| Pediasure Vanilla Btl. | 24 | 1,521 | 36,504 | Pediasure w/Fiber Btl. | 24 | 3276 | 78,624 | NeoSure new | 6 | 2114 | 12,684 |
| PediaSure W/Fiber 1.5 CAL 1.1qt | 8 | 172 | 1,376 | PediaSure With Fiber 1.5 Cal 8oz | 24 | 416 | 9,984 | PediaSure (Vanilla) 1.5 CAL 8oz | 24 | 192 | 4,608 |
| Pediasure w/Fiber Btl. | 24 | 2,925 | 70,200 | Similac 60/40 | 6 | 16 | 96 | Pediasure Banana Btls | 24 | 25 | 600 |
| PediaSure With Fiber 1.5 Cal 8oz | 24 | 75 | 1,800 | Similac Neosure RTU 32oz. | 6 | 1450 | 8,700 | PediaSure Peptide (Vanilla) | 24 | 278 | 6,672 |
| Similac 60/40 | 6 | 28 | 168 | Pediasure Strawberry Btl. | 24 | 444 | 10,656 | ||||
| Similac Neosure RTU 32oz. | 6 | 1,120 | 6,720 | Pediasure Vanilla Btl. | 24 | 1117 | 26,808 | ||||
| Pediasure w/Fiber Btl. | 24 | 1512 | 36,288 | ||||||||
| PediaSure With Fiber 1.5 Cal 8oz | 24 | 358 | 8,592 | ||||||||
| Grand Total | 150,384 | 1,067,134 | Grand Total | 123,167 | 896,985 | Similac 60/40 | 6 | 41 | 246 | ||
| Similac Neosure RTU 32oz. | 6 | 1735 | 10,410 |
Grand Total 52,454 408,085
File details come from the government source that posted it. Updated .