Attachment D - 2023 Rebate Bid Sheet~1.xlsx
XLSX spreadsheet 48 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 Invitation for Bids (IFB) from the Illinois Department of Human Services WIC Program for an Infant Formula Rebate program. The program is seeking bids from infant formula manufacturers to supply and provide a rebate on all infant formulas that the State chooses to issue, except for exempt infant formulas, for the WIC program. The contract will cover a range of infant formula products and physical forms including powdered, liquid concentrate, and ready-to-feed. The IFB provides detailed information on the estimated number of infant participants and monthly allowances for each formula type and age group. Bids must be submitted using the provided Rebate Bid Sheet template and meet all federal regulatory requirements.
The IFB outlines the pricing structure, requiring bidders to provide the lowest national wholesale price per unit for a full truckload as well as the rebate bid per unit. The rebate bid will determine the net cost per unit and total net cost per month for the State. No minimum or maximum quantities are guaranteed. The contract term and any renewal options are not specified in the IFB.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment B - Food Center Addresses.xlsx | XLSX spreadsheet | |
| Attachment E-2 - 11 months non-Rebate Formula redemptions 2021-2022.pdf | ||
| Attachment F-2 - FFY21 Rebate Receipts.pdf | ||
| Attachment F-3 - FFY20 Rebate Receipts.pdf | ||
| Attachment H - Active Vendors February 2022.xlsx | XLSX spreadsheet | |
| Attachment I - Food Center WIC Formula Purchases 3-year Trend.xlsx | XLSX spreadsheet | |
| DHS IFB WIC Infant Formula-B-28401.docx | DOCX document | |
| Attachment C - WIC Food Center Information.docx | DOCX document | |
| Questions and Answers for B-28401~1.pdf | ||
| Attachment E-1 - 11 months Rebate Formula redemptions 2021-2022.pdf | ||
| Attachment F-1 - FFY22 Rebate Receipts.pdf | ||
| B-28401 Notice of Award Form v.22.1_41.pdf | ||
| Forms A~44.docx | DOCX document | |
| Attachment A - Federal Participation.docx | DOCX document | |
| Attachment G - Infant Formula Invoices 2021-2022.pdf | ||
| Forms B~60.docx | DOCX document | |
| Notice of Electronic Submission Only v.22.1~39.pdf |
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
Rebate Bid Sheet1
| Attachment D |
| Illinois Department of Human Services WIC Program |
| WIC Infant Formula Rebate—Bid Sheet, Page 1 of 2 |
CARRY ALL FIGURES TO THREE (3) DECIMAL PLACES
Instructions: Enter manufacturer's name, product name, UPC code, unit size, reconstituted ounce per unit, lowest national wholesale price per unit for a full truckload, and rebate bid per unit in the chart below.
| Data entry fields are yellow sections. |
| Calculations will be performed automatically within the spreadsheet in Page 2. |
| Sign and Notarize this page. |
| Manufacturer: | ||||||||
| Physical Form | Product Name Being Bid | UPC Code | Unit Size (in Ounces) | Reconstituted Ounce Per Unit | Lowest Wholesale Full Truckload Price Per Unit | Rebate Bid Per Unit | Net Cost | Percent Rebate Discount |
| Powdered | $0.000 | ERROR:#DIV/0! | ||||||
| Liquid Concentrate | $0.000 | ERROR:#DIV/0! | ||||||
| Ready-to-Feed | $0.000 | ERROR:#DIV/0! |
| **No assurance is given as to any minimum or maximum number of infant participants. Likewise, 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 Invitation to Bid |
| Certification |
| The bidder hereby certifies that the company is registered under the Food, Drug and Cosmetic Act with the United States Department of Health & Human Services and its products are in compliance with Federal regulations issued pursuant to P.L. 100-237. Bids for all physical forms of formula must meet the requirements of 246.10 (e) (l)(iii) and 246.10(e)(2)(iii) and be suitable for the routine issuance to the majority of generally healthy, full term infants. |
| Each infant formula product to be supplied under the terms of the contract complies with the Federal Food, Drug, and Cosmetic Act. |
| The Bidder certifies that the company 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. |
| Signature | Date |
| Notarized Signature: | |
| Seal/Date |
Rebate Bid Sheet2
| Illinois Department of Human Services | |
| WIC Infant Formula Rebate Page 2 of 2 | |
| ALL FIGURES MUST BE AT LEAST THREE (3) DECIMAL PLACES |
All cells highlighted salmon will automatically populate from bidder's data entered into Page 1
| Physical Form, Product Brand Name, and Unit Size | Reconstituted Ounces Per Unit | Infant Age Categories | Number of Reconstituted Ounces Issued per Month (based on MMA)** | Estimated Average # Infants by Form Based on 6 Months Average* | Total MMA Reconstituted Ounces to Bid | Total Monthly Units | Lowest Wholesale Full Truckload Price Per Unit | Rebate Per Unit | Net Cost Per Unit | Total Net Cost | |||
| Type: | Powdered | FF | PBF | FF | PBF | ||||||||
| Name: | 0 | 0.0 | 0-3 months | 870 | 435 | 8357 | 2735 | 24,245,576 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! |
| Ounces: | 0 | 4-5 months | 960 | 522 | 4106 | 1344 | |||||||
| 6-11 months | 696 | 384 | 13561 | 4438 | |||||||||
| Type: | Liquid Concentrate | FF | PBF | FF | PBF | ||||||||
| Name: | 0 | 0.0 | 0-3 months | 823 | 388 | 114 | 37 | 352,905 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! |
| Ounces: | 0 | 4-5 months | 896 | 460 | 64 | 21 | |||||||
| 6-11 months | 630 | 315 | 242 | 79 | |||||||||
| Type: | Ready-to-Feed | FF | PBF | FF | PBF | ||||||||
| Name: | 0 | 0.0 | 0-3 months | 832 | 384 | 123 | 40 | 306,241 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! |
| Ounces: | 0 | 4-5 months | 913 | 474 | 51 | 17 | |||||||
| 6-11 months | 643 | 338 | 179 | 58 | |||||||||
| Total Net | ERROR:#DIV/0! | ||||||||||||
| Cost Per Month | |||||||||||||
| * Based on six months of the most recent data available () | |||||||||||||
| * Excludes those infants exclusively breastfed or issued exempt infant formula | |||||||||||||
| **Based on WIC Program Regulations (§246.10(e)(9)(Table 1) and §246.16a(c)(5)(i)) |
FNBMMA
| Table 1 - Full Nutrition Benefit (FNB) and Maximum Monthly Allowances (MMA) of Supplemental Foods for Infants in Food Packages I, II and III | ||||||
| Foods1 | Fully formula fed (FF) | Partially (mostly) breastfed (BF/FF) | Fully breastfed (BF) | |||
| Food Packages | Food Packages | Food Packages | Food Packages | Food | Food | |
| I-FF & | II-FF & | I-BF/FF & III BF/FF | II-BF/FF & III | Package | Package | |
| III-FF | III-FF | (A: 0 to 1 month2 3) | BF/FF | I-BF | II-BF | |
| A: 0 through 3 months | 6 through 11 months | B: 1 through 3 months | 6 through 11 months | 0 through 5 months | 6 through 11 months | |
| B: 4 through 5 months | C: 4 through 5 months | |||||
| WIC Formula4 5 6 7 8 | A: FNB = 806 fl oz, MMA = 823 fl oz, reconstituted liquid concentrate or 832 fl. oz. RTF or 870 fl oz reconstituted powder | FNB = 624 fl oz, MMA = 630 fl oz, reconstituted liquid concentrate | A: 104 fl oz reconstituted powder | FNB = 312 fl oz, MMA = 315 fl oz, reconstituted liquid concentrate or 338 fl oz RTF or 384 fl oz reconstituted powder | ||
| or 643 fl. oz RTF or 696 fl oz reconstituted powder | B: FNB = 364 fl oz, MMA = 388 fl oz, reconstituted liquid concentrate or 384 fl oz RTF or 435 fl oz reconstituted powder | |||||
| B: FNB = 884 fl oz, MMA = 896 fl oz, reconstituted liquid concentrate or 913 fl oz RTF or 960 fl oz reconstituted powder | ||||||
| C: FNB = 442 fl oz, MMA = 460 fl oz, reconstituted liquid concentrate or 474 fl oz RTF or 522 fl oz reconstituted powder | ||||||
| Infant Cereal9 11 | 24 oz | 24 oz | 24 oz. | |||
| Infant food fruits and vegetables9 10 11 12 13 | 128 oz | 128 oz | 256 oz. | |||
| Infant food meat9 | 77.5 oz. | |||||
| Table 1 footnotes: (Abbreviations in order of appearance in table): FF = fully formula fed; BF/FF = partially (mostly) breastfed; BF = fully breastfed; RTF = Ready-to-feed; N/A = the supplemental food is not authorized in the corresponding food package. | ||||||
| 1 Table 4 of paragraph (e)(12) of this section describes the minimum requirements and specifications for the supplemental foods. The competent professional authority (CPA) is authorized to determine nutritional risk and prescribe supplemental foods as established by State agency policy in Food Packages I and II. In Food Package III, the CPA, as established by State agency policy, is authorized to determine nutritional risk and prescribe supplemental foods per medical documentation. | ||||||
| 2 State agencies have the option to issue not more than one can of powder infant formula in the container size that provides closest to 104 reconstituted fluid ounces to breastfed infants on a case-by-case basis. | ||||||
| 3 Liquid concentrate and ready-to-feed (RTF) may be substituted at rates that provide comparable nutritive value. | ||||||
| 4 WIC formula means infant formula, exempt infant formula, or WIC-eligible nutritionals. Infant formula may be issued for infants in Food Packages I, II and III. Medical documentation is required for issuance of infant formula, exempt infant formula, WIC-eligible nutritionals, and other supplemental foods in Food Package III. Only infant formula may be issued for infants in Food Packages I and II. | ||||||
| 5 The full nutrition benefit is defined as the minimum amount of reconstituted fluid ounces of liquid concentrate infant formula as specified for each infant food package category and feeding variation (e.g., Food Package IA-fully formula fed). | ||||||
| 6 The maximum monthly allowance is specified in reconstituted fluid ounces for liquid concentrate, RTF liquid, and powder forms of infant formula and exempt infant formula. Reconstituted fluid ounce is the form prepared for consumption as directed on the container. | ||||||
| 7 State agencies must provide at least the full nutrition benefit authorized to non-breastfed infants up to the maximum monthly allowance for the physical form of the product specified for each food package category. State agencies must issue whole containers that are all the same size of the same physical form. Infant formula amounts for breastfed infants, even those in the fully formula fed category should be individually tailored to the amounts that meet their nutritional needs. | ||||||
| 8 State agencies may round up and disperse whole containers of infant formula over the food package timeframe to allow participants to receive the full nutrition benefit. State agencies must use the methodology described in accordance with paragraph (h)(1) of this section. | ||||||
| 9 State agencies may round up and disperse whole containers of infant foods (infant cereal, fruits and vegetables, and meat) over the Food Package timeframe. State agencies must use the methodology described in accordance with paragraph (h)(2) of this section. | ||||||
| 10 At State agency option, for infants 6-12 months of age, fresh banana may replace up to 16 ounces of infant food fruit at a rate of 1 pound of bananas per 8 ounces of infant food fruit. State agencies may also substitute fresh bananas at a rate of 1 banana per 4 ounces of jarred infant food fruit, up to a maximum of 16 ounces. | ||||||
| 11 In lieu of infant foods (cereal, fruit and vegetables), infants greater than 6 months of age in Food Package III may receive infant formula, exempt infant formula or WIC-eligible nutritionals at the same maximum monthly allowance as infants ages 4 through 5 months of age of the same feeding option. | ||||||
| 12 At State agency option, infants 9 months through 11 months in Food Packages II and III may receive a cash-value voucher to purchase fresh (only) fruits and vegetables in lieu of a portion of the infant food fruits and vegetables. Partially (mostly) breastfed infants and fully formula fed infants may receive a $4 cash-value voucher plus 64 ounces of infant food fruits and vegetables; fully breastfeeding infants may receive a $8 cash-value voucher plus 128 ounces of infant food fruit and vegetables. | ||||||
| 13 State agencies may not categorically issue cash-value vouchers for infants 9 months through 11 months. The cash-value voucher is to be provided to the participant only after an individual nutrition assessment, as established by State agency policy, and is optional for the participant, i.e., the mother may choose to receive either the maximum allowance of jarred foods or a combination of jarred foods and a fruit and vegetable cash-value voucher for her infant. State agencies must ensure that appropriate nutrition education is provided to the caregiver addressing safe food preparation, storage techniques, and feeding practices to make certain participants are meeting their nutritional needs in a safe and effective manner. | ||||||
| Source: | https://www.ecfr.gov/current/title-7/subtitle-B/chapter-II/subchapter-A/part-246#p-246.10(e)(9) |
| Table 3 - Maximum Monthly Allowances (MMA) of Supplemental Foods for Children and Women With Qualifying Conditions in Food Package III | ||||
| Foods1 | Children | Women | ||
| 1 through 4 years | Pregnant and partially breastfeeding (up to 1 year postpartum)2 | Postpartum (up to 6 months postpartum)3 | Fully breastfeeding, (up to 1 year post-partum)45 | |
| Juice, single strength6 | 128 fl oz | 144 fl oz | 96 fl oz | 144 fl oz. |
| WIC Formula78 | 455 fl oz liquid concentrate | 455 fl oz liquid concentrate | 455 fl oz liquid concentrate | 455 fl oz liquid concentrate. |
| Milk | 16 qt910111213 | 22 qt910111214 | 16 qt910111214 | 24 qt910111214. |
| Breakfast cereal1516 | 36 oz | 36 oz | 36 oz | 36 oz. |
| Cheese | N/A | N/A | N/A | 1 lb. |
| Eggs | 1 dozen | 1 dozen | 1 dozen | 2 dozen. |
| Fruits and vegetables171819 | $8.00 in cash-value vouchers | $10.00 in cash-value vouchers | $10.00 in cash-value vouchers | $10.00 in cash-value vouchers. |
| Whole wheat or whole grain bread20 | 2 lb | 1 lb | N/A | 1 lb. |
| Fish (canned) | N/A | N/A | N/A | 30 oz. |
| Legumes, dry21 and/or Peanut butter | 1 lb or 18 oz | 1 lb and 18 oz | 1 lb or 18 oz | 1 lb and 18 oz. |
| Table 3 Footnotes: N/A = the supplemental food is not authorized in the corresponding food package. | ||||
| 1 Table 4 of paragraph (e)(12) of this section describes the minimum requirements and specifications for the supplemental foods. The competent professional authority (CPA), as established by State agency policy, is authorized to determine nutritional risk and prescribe supplemental foods per medical documentation. | ||||
| 2 This food package is issued to two categories of WIC participants: Women participants with singleton pregnancies and breastfeeding women whose partially (mostly) breastfed infants receive formula from the WIC Program in amounts that do not exceed the maximum formula allowances as appropriate for the age of the infant as described in Table 1 of paragraph (e)(9) of this section. | ||||
| 3 This food package is issued to two categories of WIC participants: Non-breastfeeding postpartum women and breastfeeding postpartum women whose breastfed infants receive more than the maximum infant formula allowances as appropriate for the age of the infant as described in Table 1 of paragraph (e)(9) of this section. | ||||
| 4 This food package is issued to four categories of WIC participants: Fully breastfeeding women whose infants do not receive formula from the WIC Program; women pregnant with two or more fetuses; women partially (mostly) breastfeeding multiple infants from the same pregnancy, and pregnant women who are also partially (mostly) breastfeeding singleton infants. | ||||
| 5 Women fully breastfeeding multiple infants from the same pregnancy are prescribed 1.5 times the maximum allowances. | ||||
| 6 Combinations of single-strength and concentrated juices may be issued provided that the total volume does not exceed the maximum monthly allowance for single-strength juice. | ||||
| 7 WIC formula means infant formula, exempt infant formula, or WIC-eligible nutritionals. | ||||
| 8 Powder and ready-to-feed may be substituted at rates that provide comparable nutritive value. | ||||
| 9 Whole milk is the standard milk for issuance to 1-year-old children (12 through 23 months). Fat-reduced milks may be issued to 1-year old children as determined appropriate by the health care provider per medical documentation. Lowfat (1%) or nonfat milks are the standard milks for issuance for children ≥24 months of age and women. Whole milk or reduced fat (2%) milk may be substituted for lowfat (1%) or nonfat milk for children ≥24 months of age and women as determined appropriate by the health care provider per medical documentation. | ||||
| 10 Evaporated milk may be substituted at the rate of 16 fluid ounces of evaporated milk per 32 fluid ounces of fluid milk or a 1:2 fluid ounce substitution ratio. Dry milk may be substituted at an equal reconstituted rate to fluid milk. | ||||
| 11 For children and women, cheese may be substituted for milk at the rate of 1 pound of cheese per 3 quarts of milk. For children and women in the pregnant, partially breastfeeding and postpartum food packages, no more than 1 pound of cheese may be substituted. For women in the fully breastfeeding food package, no more than 2 pounds of cheese may be substituted for milk. State agencies do not have the option to issue additional amounts of cheese beyond these maximums even with medical documentation. (No more than a total of 4 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for children and women in the pregnant, partially breastfeeding and postpartum food packages. No more than a total of 6 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for women in the fully breastfeeding food package.) | ||||
| 12 For children and women, yogurt may be substituted for fluid milk at the rate of 1 quart of yogurt per 1 quart of milk; a maximum of 1 quart of milk can be substituted. Additional amounts of yogurt are not authorized. Whole yogurt is the standard yogurt for issuance to 1-year-old children (12 through 23 months). Lowfat or nonfat yogurt may be issued to 1-year-old children (12 months to 23 months) as determined appropriate by the health care provider per medical documentation. Lowfat or nonfat yogurts are the standard yogurt for issuance to children ≥24 months of age and women. Whole yogurt may be substituted for lowfat or nonfat yogurt for children ≥24 months of age and women as determined appropriate by the health care provider per medical documentation. (No more than a total of 4 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for children and women in the pregnant, partially breastfeeding and postpartum food packages. No more than a total of 6 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for women in the fully breastfeeding food package.) | ||||
| 13 For children, soy-based beverage and tofu may be substituted for milk as determined appropriate by the health care provider per medical documentation. Soy-based beverage may be substituted for milk on a quart for quart basis up to the total maximum allowance of milk. Tofu may be substituted for milk for children at the rate of 1 pound of tofu per 1 quart of milk. (No more than a total of 4 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for children.) Additional amounts of tofu may be substituted, up to the maximum allowance for fluid milk for children, as determined appropriate by the health care provider per medical documentation. | ||||
| 14 For women, soy-based beverage may be substituted for milk on a quart for quart basis up to the total maximum monthly allowance of milk. Tofu may be substituted for milk at the rate of 1 pound of tofu per 1 quart of milk. (No more than a total of 4 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for women in the pregnant, partially breastfeeding and postpartum food packages. No more than a total of 6 quarts of milk may be substituted for a combination of cheese, yogurt or tofu for women in the fully breastfeeding food package.) Additional amounts of tofu may be substituted, up to the maximum allowances for fluid milk, as determined appropriate by the health care provider per medical documentation. | ||||
| 15 32 dry ounces of infant cereal may be substituted for 36 ounces of breakfast cereal as determined appropriate by the health care provider per medical documentation. | ||||
| 16 At least one half of the total number of breakfast cereals on the State agency's authorized food list must have whole grain as the primary ingredient and meet labeling requirements for making a health claim as a “whole grain food with moderate fat content” as defined in Table 4 of paragraph (e)(12) of this section. | ||||
| 17 Both fresh fruits and fresh vegetables must be authorized by State agencies. Processed fruits and vegetables, i.e., canned (shelf-stable), frozen, and/or dried fruits and vegetables may also be authorized to offer a wider variety and choice for participants. State agencies may choose to authorize one or more of the following processed fruits and vegetables: canned fruit, canned vegetables, frozen fruit, frozen vegetables, dried fruit, and/or dried vegetables. The cash-value voucher may be redeemed for any eligible fruit and vegetable (refer to Table 4 of paragraph (e)(12) of this section and its footnotes). Except as authorized in paragraph (b)(1)(i) of this section, State agencies may not selectively choose which fruits and vegetables are available to participants. For example, if a State agency chooses to offer dried fruits, it must authorize all WIC-eligible dried fruits. | ||||
| 18 Children and women whose special dietary needs require the use of pureed foods may receive commercial jarred infant food fruits and vegetables in lieu of the cash-value voucher. Children may receive 128 oz of commercial jarred infant food fruits and vegetables and women may receive 160 oz of commercial jarred infant food fruits and vegetables in lieu of the cash-value voucher. Infant food fruits and vegetables may be substituted for the cash-value voucher as determined appropriate by the health care provider per medical documentation. | ||||
| 19 The monthly value of the fruit/vegetable cash-value vouchers will be adjusted annually for inflation as described in § 246.16(j). | ||||
| 20 Whole wheat and/or whole grain bread must be authorized. State agencies have the option to also authorize brown rice, bulgur, oatmeal, whole-grain barley, whole wheat macaroni products, or soft corn or whole wheat tortillas on an equal weight basis. | ||||
| 21 Canned legumes may be substituted for dry legumes at the rate of 64 oz. (e.g., four 16-oz cans) of canned beans for 1 pound dry beans. In Food Packages V and VII, both beans and peanut butter must be provided. However, when individually tailoring Food Packages V or VII for nutritional reasons (e.g., food allergy, underweight, participant preference), State agencies have the option to authorize the following substitutions: 1 pound dry and 64 oz. canned beans/peas (and no peanut butter); or 2 pounds dry or 128 oz. canned beans/peas (and no peanut butter); or 36 oz. peanut butter (and no beans). | ||||
| Source: | https://www.ecfr.gov/current/title-7/subtitle-B/chapter-II/subchapter-A/part-246#p-246.10(e)(11) |
https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/subtitle-B/chapter-II/subchapter-A/part-246https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.10https://www.ecfr.gov/current/title-7/section-246.16https://www.ecfr.gov/current/title-7/subtitle-B/chapter-II/subchapter-A/part-246
DATA SHEET
| FFY 2021 | Illinois Data used for the IFB Bid Sheet | |||||||||||
| 16 | October | November | December | January | February | March | April | May | June | July | August | September |
| b. Infants Partially Breastfed | 8,223 | 7,979 | 8,552 | 9,150 | 9,305 | 9,695 | 9,701 | 9,659 | 9,786 | 9,895 | 10,046 | 10,241 |
| c. Infants Fully Formula-fed | 35,924 | 34,950 | 34,286 | 33,689 | 32,715 | 32,154 | 31,627 | 30,959 | 30,651 | 30,159 | 29,259 | 28,644 |
| Last 6 month Average | Reduced to account for medically prescribed | Averages | |||||||||||||||||||||||||||||||
| Type of Formula | Age Group | Count of Infants | % Infants by type of formula | IPB | IFF | Total February 2021 | IPB | IFF | Total March 2021 | IPB | IFF | Total April 2021 | IPB | IFF | Total May 2021 | IPB | IFF | Total June 2021 | IPB | IFF | Total July 2021 | IPB | IFF | Total August 2021 | IPB | IFF | Total September 2021 | IPB Average | IFF Average | IPB Average | IFF Average | LAST SIX MONTH AVERAGE (ROUNDED TO NEAREST INTEGER) | YTD AVERAGE (ROUNDED TO NEAREST INTEGER) |
| Powder | 0-3 | 14554 | 31.19% | 2902 | 10203 | 13106 | 3024 | 10028 | 13052 | 3026 | 9864 | 12890 | 3013 | 9656 | 12668 | 3052 | 9560 | 12612 | 3086 | 9406 | 12492 | 3133 | 9126 | 12259 | 3194 | 8934 | 12128 | 3084 | 9424 | 2735 | 8357 | 12508 | 12651 |
| Powder | 4-5 | 7150 | 15.32% | 1426 | 5013 | 6438 | 1485 | 4927 | 6412 | 1486 | 4846 | 6332 | 1480 | 4744 | 6224 | 1499 | 4696 | 6196 | 1516 | 4621 | 6137 | 1539 | 4483 | 6022 | 1569 | 4389 | 5958 | 1515 | 4630 | 1344 | 4106 | 6145 | 6215 |
| Powder | 6-12 | 23615 | 50.61% | 4709 | 16556 | 21265 | 4906 | 16272 | 21178 | 4909 | 16005 | 20915 | 4888 | 15667 | 20555 | 4952 | 15511 | 20464 | 5008 | 15262 | 20270 | 5084 | 14807 | 19891 | 5183 | 14496 | 19678 | 5004 | 15292 | 4438 | 13561 | 20295 | 20527 |
| Concentrate | 0-3 | 199 | 0.43% | 40 | 140 | 179 | 41 | 137 | 178 | 41 | 135 | 176 | 41 | 132 | 173 | 42 | 131 | 172 | 42 | 129 | 171 | 43 | 125 | 168 | 44 | 122 | 166 | 42 | 129 | 37 | 114 | 171 | 173 |
| Concentrate | 4-5 | 111 | 0.24% | 22 | 78 | 100 | 23 | 76 | 100 | 23 | 75 | 98 | 23 | 74 | 97 | 23 | 73 | 96 | 24 | 72 | 95 | 24 | 70 | 93 | 24 | 68 | 92 | 24 | 72 | 21 | 64 | 95 | 96 |
| Concentrate | 6-12 | 422 | 0.90% | 84 | 296 | 380 | 88 | 291 | 378 | 88 | 286 | 374 | 87 | 280 | 367 | 88 | 277 | 366 | 89 | 273 | 362 | 91 | 265 | 355 | 93 | 259 | 352 | 89 | 273 | 79 | 242 | 363 | 367 |
| RTU | 0-3 | 214 | 0.46% | 43 | 150 | 193 | 44 | 147 | 192 | 44 | 145 | 190 | 44 | 142 | 186 | 45 | 141 | 185 | 45 | 138 | 184 | 46 | 134 | 180 | 47 | 131 | 178 | 45 | 139 | 40 | 123 | 184 | 186 |
| RTU | 4-5 | 88 | 0.19% | 18 | 62 | 79 | 18 | 61 | 79 | 18 | 60 | 78 | 18 | 58 | 77 | 18 | 58 | 76 | 19 | 57 | 76 | 19 | 55 | 74 | 19 | 54 | 73 | 19 | 57 | 17 | 51 | 76 | 76 |
| RTU | 6-12 | 311 | 0.67% | 62 | 218 | 280 | 65 | 214 | 279 | 65 | 211 | 275 | 64 | 206 | 271 | 65 | 204 | 269 | 66 | 201 | 267 | 67 | 195 | 262 | 68 | 191 | 259 | 66 | 201 | 58 | 179 | 267 | 270 |
| 46664 | 9305 | 32715 | 42020 | 41849 | 41328 | 40618 | 40437 | 40054 | 39305 | 38885 | |||||||||||||||||||||||
| Multiplier used to reduce | |||||||||||||||||||||||||||||||||
| formula usage for those | |||||||||||||||||||||||||||||||||
| with medically prescribed | |||||||||||||||||||||||||||||||||
| formula. Used in the | |||||||||||||||||||||||||||||||||
| calculations above: * | |||||||||||||||||||||||||||||||||
| 0.8868 |
| * as determined from analysis of formula issued |
| between September 2021 to January 2022 |
| (See Formula Useage Summary file) |
File details come from the government source that posted it. Updated .