Attachment D Bid Sheet Template-Single Solicitation July 2024.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- IFB Infant Formula Rebate Program
- Solicitation number
- 25-444DHS-FAMCO-B-47390
- Issued by
- Illinois
About this file
This document is a WIC (Women, Infants, and Children) Infant Formula Bid Sheet Template designed for state agencies to conduct a single-supplier competitive bid solicitation for infant formula, aligned with federal requirements under 7 C.F.R. 246.10(e)(9)(Table 1) and 246.16a(c)(2, 4-7). The bid sheet covers three physical formula types (powdered, liquid concentrate, and ready-to-feed) across three infant age categories (0-3 months, 4-5 months, and 6-11 months), with estimated monthly distribution quantities ranging from 7 to 14,431 units depending on infant age and formula type.
The bid sheet requires manufacturers to provide detailed pricing information, including lowest wholesale full truckload prices, rebate bids per unit, and net prices, with specific certification requirements ensuring compliance with the Food, Drug and Cosmetic Act. Manufacturers must be able to supply 100% of the WIC Program's infant formula needs across all geographic areas outlined in the solicitation. The template emphasizes that no quantity guarantees are provided, and the estimated infant numbers are approximations excluding exclusively breastfed infants or those requiring exempt infant formulas. Bidders are expected to complete specific gray-highlighted cells with precise pricing data and sign the certification statements.
View the file
Other files
Show all 14
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
Infant Formula Bid Sheet
| WIC Infant Formula Rebate Bid Sheet Template for a Single Bid Solicitation |
| Purpose: Template for WIC State agencies to use in order to collect bids for primary contract infant formula as part of its single-supplier competitive bid solicitation to meet the federal requirements outlined in 7 C.F.R. 246.10(e)(9)(Table 1) and §246.16a(c)(2, 4-7). |
| Instructions for the WIC State agency: Please complete all fillable cells in this template highlighted in pink (i.e., cells K8:L16; B25:E25). |
| Instructions for the Bidder: Please complete all fillable cells in this template highlighted in gray (i.e., cells B8:G16; B26:E26; K25:Q26) and read through the certification statements below. Please provide data to at least 3 decimal places when possible. Once complete, please sign and reference procurement instructions provided in the State agency's bid solicitation. |
| Physical Form | Product Name | UPC Code | Unit Size (in ounces) | Reconstituted Ounce Per Unit | Lowest Wholesale Full Truckload Price Per Unit | Rebate Bid Per Unit | Infant Age Categories | Number of Reconstituted Ounces Issued per Month Based on Max* | Estimated Average Number of Infants by Physical Form Based on 6 Months Average** | Net Price Per Unit | Percent Rebate | Total Monthly Reconstituted Ounces to Bid | Standardized Number of Units of Infant Formula | Total Cost | ||
| Fully Formula Fed Infants | Partially Breastfed Infants | Fully Formula Fed Infants | Partially Breastfed Infants | |||||||||||||
| Powdered | 0-3 months | 870 | 435 | 4,537 | 4,666 | $0.000 | ERROR:#DIV/0! | 22,749,756 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 960 | 522 | 3,854 | 2,424 | ||||||||||||
| 6-11 months | 696 | 384 | 14,431 | 4,593 | ||||||||||||
| Liquid Concentrate | 0-3 months | 823 | 388 | 25 | 16 | $0.000 | ERROR:#DIV/0! | 88,730 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 896 | 460 | 17 | 5 | ||||||||||||
| 6-11 months | 630 | 315 | 63 | 15 | ||||||||||||
| Ready-to-Feed | 0-3 months | 832 | 384 | 9 | 9 | $0.000 | ERROR:#DIV/0! | 37,705 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 913 | 474 | 7 | 6 | ||||||||||||
| 6-11 months | 643 | 338 | 22 | 10 | ||||||||||||
| *Based on WIC Program Regulations (§246.10(e)(9)(Table 1) and §246.16a(c)(5)(i)) | Total Monthly Price | ERROR:#DIV/0! | ||||||||||||||
| **Estimated average based on six months of the most recent data available. Excludes infants that are exclusively breastfed or issued exempt infant formula and includes infants that are issued milk- or soy- based infant formula. |
Please Note: No assurances are provided on the quantity, type, or physical forms that will be issued under the agreement that will become a result of this bid solicitation. Additionally, the estimated average number of infants provided on this bid sheet is an approximation and excludes infants that are exclusively breastfed or issued exempt infant formula.
| Certification: |
| The bidder hereby certifies that: |
1. The bidder is registered under the Food, Drug and Cosmetic Act with the U.S. Department of Health & Human Services and its products are in compliance with Federal regulations issued pursuant to P.L. 100-237.
2. Bids for all physical forms of formula meet the requirements of 246.10 (e) (1)(iii) and 246.10(e)(2)(iii) and are suitable for the routine issuance to the majority of generally healthy, full term infants.
3. Each infant formula product to be supplied under the terms of this contract complies with the Federal Food, Drug, and Cosmetic Act.
4. The bidder can and will supply the quantities of infant formula offered to meet one hundred percent (100%) of the WIC Program’s needs in all geographic areas as outlined in the bid solicitation.
| State Agency Name: | Manufacturer's Signature: |
| Manufacturer Name: |
File details come from the government source that posted it. Updated .