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

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/19Case PacksCasesUnits07/01/19 to 06/30/20Case PacksCasesUnits07/01/20 to 06/30/21Case PacksCasesUnits
MSS/Nutricia418MSS/Nutricia503MSS/Nutricia689
Neocate EO28 Splash Orange-Pineapple271203,240Neocate EO28 Splash Orange-Pineapple27832,241Neocate EO28 Splash Orange-Pineapple271494,023
Neocate Junior 14 o.z.466264Neocate Junior 14 o.z.460240Neocate E028 Splash Tropical2715405
Neocate Syneo Infant472288Neocate Syneo Infant41560Neocate EO28 Splash UnFlavored27391,053
Neocate W/DHA & ARA Powder4160640Neocate W/DHA & ARA Powder43451,380Neocate Junior 14 o.z.43751,500
Neocate Junior Chocolate Powder427108
Mead Johnson133,406Mead Johnson106,109Neocate Junior Strawberry Powder4416
EnfaCare RTU 8oz.47052,820Enfamil A.R. RTU 8oz.42080Neocate Syneo Infant41872
Enfamil A.R. RTU 8oz.460240Enfamil Gentlease Pwd631676190,056Neocate W/DHA & ARA Powder462248
Enfamil Gentlease Pwd633,423200,538Enfamil Infant AR Pwdr6518231,092
Enfamil Infant AR Pwdr65,47232,832Enfamil Infant Conc. Liq12612073,440Mead Johnson42,416
Enfamil Infant Conc. Liq126,46077,520Enfamil Infant Pwd WIC659520357,120Enfamil Gentlease Pwd61598795,922
Enfamil Infant Pwd WIC684,510507,060Enfamil Infant RTU 32oz.62001,200Enfamil Infant AR Pwdr614768,856
Enfamil Infant RTU 32oz.6120720Enfamil NeuroPro EnfaCare Pwd. 12.8oz613598,154Enfamil Infant Conc. Liq12301836,216
Enfamil NeuroPro EnfaCare Pwd. 12.8oz61,79210,752Enfamil NeuroPro Infant RTU 32oz.44501,800Enfamil Infant Pwd WIC619791118,746
Enfamil ProSobee RTU 8oz.425100Enfamil ProSobee RTU 8oz.4832Enfamil Infant RTU 32oz.61911,146
Enfamil Reguline Powder64712,826Enfamil Reguline Powder613287,968Enfamil NeuroPro EnfaCare Pwd. 12.8oz611356,810
Pregestamil Powder632192Pregestamil Powder632192Enfamil ProSobee RTU 32oz465260
ProSobee Liq WIC123063,672ProSobee Liq WIC121702,040Enfamil Reguline Powder64582,748
PURAMINO (DHA & ARA) Powder430120PURAMINO (DHA & ARA) Powder444176Pregestamil Powder649294
ProSobee Liq WIC1242504
Nestles USA70Nestles USA8ProSobee Pwd WIC6133798
Nutren Jr. w/Fiber2428672Nutren Jr. w/Fiber248192PURAMINO (DHA & ARA) Powder471284
Peptamen Junior W/Fiber2425600
Nutren Junior Liquid Vanilla2417408Ross Laboratories16,547Nestles USA35
Alimentum Adv Iron 32oz62751,650Nutren Jr. w/Fiber2425600
Ross Laboratories16,490Alimentum w/DHA-E & Protein614248,544Peptamen Junior W/Fiber245120
Alimentum Adv Iron 32oz64302,580EleCare for Infants62881,728Nutren Junior Liquid Vanilla245120
Alimentum w/DHA-E & Protein69125,472EleCare Junior (Banana)61484
EleCare for Infants62241,344EleCare Junior (Unflavored)693558Ross Laboratories9,314
EleCare Junior (Unflavored)662372EleCare Junior (Vanilla)6117702Alimentum Adv Iron 32oz694564
EleCare Junior (Vanilla)6128768NeoSure new6619037,140Alimentum w/DHA-E & Protein66333,798
NeoSure new66,61739,702PediaSure (Vanilla) 1.5 CAL 8oz242074,968EleCare for Infants62491,494
PediaSure (Vanilla) 1.5 CAL 8oz243077,368Pediasure Peptide (Strawberry)241102,640EleCare Junior (Banana)639234
Pediasure Peptide (Strawberry)241102,640PediaSure Peptide (Vanilla)2444810,752EleCare Junior (Unflavored)62071,242
PediaSure Peptide (Vanilla)2445510,920Pediasure Strawberry Btl.2493622,464EleCare Junior (Vanilla)62381,428
Pediasure Strawberry Btl.241,40433,696Pediasure Vanilla Btl.24128730,888Ensure Plus Vanilla2438912
Pediasure Vanilla Btl.241,52136,504Pediasure w/Fiber Btl.24327678,624NeoSure new6211412,684
PediaSure W/Fiber 1.5 CAL 1.1qt81721,376PediaSure With Fiber 1.5 Cal 8oz244169,984PediaSure (Vanilla) 1.5 CAL 8oz241924,608
Pediasure w/Fiber Btl.242,92570,200Similac 60/4061696Pediasure Banana Btls2425600
PediaSure With Fiber 1.5 Cal 8oz24751,800Similac Neosure RTU 32oz.614508,700PediaSure Peptide (Vanilla)242786,672
Similac 60/40628168Pediasure Strawberry Btl.2444410,656
Similac Neosure RTU 32oz.61,1206,720Pediasure Vanilla Btl.24111726,808
Pediasure w/Fiber Btl.24151236,288
PediaSure With Fiber 1.5 Cal 8oz243588,592
Grand Total150,3841,067,134Grand Total123,167896,985Similac 60/40641246
Similac Neosure RTU 32oz.6173510,410

Grand Total 52,454 408,085

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