RFP 26-1094 Amendment 1 Schedule B - Bid Sheet Template-Single Solicitation March 2026.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- RFP 491 260000001094 2
- Issued by
- Michigan
About this file
This is a Bid Sheet Template Amendment 1 for RFP 26-1094, issued by the Michigan Department of Health and Human Services (MDHHS) WIC Program for the WIC Infant Formula Rebate Program. The template is designed for use in a single-supplier competitive bid solicitation to meet federal requirements outlined in 7 C.F.R. 246.10(e)(9) and 246.16a(c). Bidders are required to submit pricing and rebate information for infant formula products across three physical forms: powdered, liquid concentrate, and ready-to-feed formulas. The bid sheet requires detailed data including product names, UPC codes, unit sizes, wholesale prices, and rebate bids organized by infant age categories (0-3 months, 4-5 months, and 6-11 months) and feeding types (fully formula fed and partially breastfed infants). The template incorporates estimated average infant populations based on six months of recent program data to calculate total monthly reconstituted ounces and standardized unit quantities needed across all geographic service areas in Michigan.
Bidders must provide pricing data to at least three decimal places and complete all gray-highlighted cells within the template, including net price per unit, percent rebate calculations, and total monthly costs. The bid sheet projects significant monthly volume requirements, including approximately 21 million reconstituted ounces for powdered formula, 28,751 ounces for liquid concentrate, and 67,616 ounces for ready-to-feed formulas. Bidders must certify compliance with the Food, Drug and Cosmetic Act, federal regulations under P.L. 100-237, and confirm their ability to supply one hundred percent of the WIC Program's formula needs across all geographic areas. The template explicitly notes that no assurances are provided regarding actual quantities, types, or physical forms that will be issued under any resulting contract, and estimated infant populations exclude exclusively breastfed infants and those issued exempt infant formulas.
View the file
Other files
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 | 6,602 | 3,128 | $0.000 | ERROR:#DIV/0! | 21,075,474 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 960 | 522 | 3,824 | 1,075 | ||||||||||||
| 6-11 months | 696 | 384 | 12,802 | 2,158 | ||||||||||||
| Liquid Concentrate | 0-3 months | 823 | 388 | 11 | 6 | $0.000 | ERROR:#DIV/0! | 28,751 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 896 | 460 | 5 | 2 | ||||||||||||
| 6-11 months | 630 | 315 | 16 | 6 | ||||||||||||
| Ready-to-Feed | 0-3 months | 832 | 384 | 22 | 10 | $0.000 | ERROR:#DIV/0! | 67,616 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4-5 months | 913 | 474 | 12 | 2 | ||||||||||||
| 6-11 months | 643 | 338 | 48 | 8 | ||||||||||||
| *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: | Michigan WIC | Manufacturer's Signature: |
| Manufacturer Name: |
File details come from the government source that posted it. Updated .