210000001676 - Schedule B - Pricing v2.xlsx
XLSX spreadsheet 57 KB Posted
- Solicitation number
- RFP 171 210000001676 4
- Issued by
- Michigan
About this file
This is a pricing schedule (Schedule B) for Request For Proposal No. 210000001676 issued by the State of Michigan for the Women, Infants, and Children (WIC) Infant Formula Rebate Program. Bidders must submit pricing information for milk-based infant formula products in three physical forms: liquid concentrate, powder, and ready-to-feed formulations. The pricing schedule requires manufacturers to enter company name, product brand name, unit size in ounces, reconstituted ounces per unit, wholesale price per unit, and rebate per unit for each formula type. Bidders must complete the schedule in a modifiable format such as Microsoft Excel or Word, with the option to submit an additional non-modifiable PDF version. Failure to complete the pricing schedule as requested may result in proposal disqualification. The bid calculation worksheet uses March 1, 2020 through February 28, 2021 participation data to project monthly volumes across multiple age groups, ranging from infants aged 0 months through 6-11 months, with average client numbers and reconstituted ounces used to determine total monthly unit requirements and net costs.
All pricing submissions must include wholesale prices and rebates per unit stated to three decimal places and must encompass all costs, including one-time or set-up charges, fees, shipping and handling, per-piece pricing, and palletizing. The bid calculation sheet automatically computes total monthly net prices based on the entered wholesale prices and rebate amounts. Participation and infant formula data used in the projections do not necessarily reflect actual issuance and redemption that will occur under the resulting contract. By submitting a proposal, contractors certify that prices were arrived at independently and without consultation, communication, or agreement with any other contractor.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 210000001676 - Schedule A - Statement of Work.docx | DOCX document | |
| 210000001676 - Standard Contract Terms v2.docx | DOCX document | |
| 210000001676 - Proposal Instructions V2.docx | DOCX document | |
| 210000001676 - Schedule B - Pricing.xlsx | XLSX spreadsheet | |
| 210000001676 QA.docx | DOCX document | |
| 210000001676 - Schedule C - Bidder Response v2.docx | DOCX document | |
| 210000001676 - Proposal Instructions V3.docx | DOCX document | |
| 210000001676 - Standard Contract Terms.docx | DOCX document | |
| 210000001676 - Schedule A - Statement of Work V3.docx | DOCX document | |
| 210000001676 - Schedule C - Bidder Response.docx | DOCX document | |
| 210000001676 - Proposal Instructions.docx | DOCX document | |
| 210000001676 - Schedule A - Statement of Work V2.docx | DOCX document |
Show all 12
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
Instructions
| Enter company name here. | |
| Michigan.gov/MiProcurement | |
| SCHEDULE B - PRICING |
| Request For Proposal No. 210000001676 |
| Women, Infants, and Children (WIC) Infant Formula Rebate Program |
| 1. The Contractor must provide a pricing schedule for the proposed Contract Activities using Schedule B, Pricing. The pricing schedule should be submitted in a modifiable format (e.g. Microsoft Word or Excel); however, you may also submit an additional pricing schedule in a non-modifiable format (e.g., PDF). Failure to complete the pricing schedule as requested may result in disqualification of your proposal. |
2. There are three tabs to Schedule B Pricing: 1) Instructions, 2) Bid Sheet and 3) Bid Calculation Sheet.
3. Under the “Bid Sheet” tab, Bidders must enter the following information: manufacturer's name, product name, powdered unit size, reconstituted ounces per unit, wholesale price per unit, refer to Schedule A, Section 4.1 Price Term (on the date of the bid opening), and rebate per unit into the chart. Data entry fields are in bold in green sections. Use the tab key to move between fields. Note that wholesale prices and rebates per unit must be submitted with 3 decimals. Calculations will be done automatically within the spreadsheet in the “Bid Calculation Sheet” tab.
4. Price proposals must include all costs, including but not limited to, any one-time or set-up charges, fees, and potential costs that Contractor may charge the State (e.g., shipping and handling, per piece pricing, and palletizing).
5. Participation and infant formula data does not necessarily reflect actual issuance and redemption that will occur under the contract resulting from this RFP.
6. By submitting its proposal, the Contractor certifies that the prices were arrived at independently, and without consultation, communication, or agreement with any other Contractor.
Bid Sheet
| MICHIGAN WIC PROGRAM |
| Rebate Bid Sheet |
| Milk Based Infant Formula |
Instructions: Enter manufacturer's name, product name, unit size, reconstituted ounces per unit, wholesale price per unit and rebate per unit in the chart below.
| Data entry fields are in bold in green sections. Use the tab key to move between fields. |
| Calculations will be done automatically within the spreadsheet in the "Bid Calculation Sheet" tab. |
| Wholesale prices and rebates per unit must be submitted with 3 decimals. |
Manufacturer:
| Physical Form | Product Brand Name | Unit Size | |||
| (oz.) | Reconstituted Oz. per Unit | Wholesale Price per Unit | Rebate Bid | ||
| per Unit | Net Cost per Unit | Percent Rebate | |||
| Liquid Concentrate | $0.000 | ERROR:#DIV/0! | |||
| Powder | $0.000 | ERROR:#DIV/0! | |||
| Ready-to-Feed | $0.000 | ERROR:#DIV/0! |
Bid Calculation Sheet
| MICHIGAN WIC PROGRAM |
| PRIMARY CONTRACT BRAND FORMULA INFORMATION |
| FORMULA BID EVALUATION WORKSHEET |
| Section I | Section II | ||||||||||||||
| INFORMATION WORKSHEET | BID CALCULATION SHEET | ||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
| Age Group / | |||||||||||||||
| Formula by Form | Monthly Maximum Reconstituted Ounces | Reconstituted Ounces per Unit (Can of Formula) | Average Number of Infants * | Total Monthly Reconstituted Ounces | Physical Form | ||||||||||
| Brand Name | Total Monthly Infants | ||||||||||||||
| (sum of infants by form under Col. D) | Unit Size | Reconstituted Oz. Per Unit | Total Reconstituted Monthly Ounces (sum of ounces by form under Col. E) | Total Monthly Units | |||||||||||
| (Col J/Col I) | Wholesale Price Per Unit | Rebate Per Unit | Net Price per Unit (Col L - Col M) | Net Cost |
(Col K * Col N)
| 0 | ||||||||||||||
| IBP Age 0 months | ||||||||||||||
| (IBP) Concentrate | 0 | 0 | 0 | Concentrate | 163 | 0.0 | 0.0 | 117,001 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! | |
| (IBP) powder | 104 | 0 | 878 | 91,312 | 0.000 | |||||||||
| (IBP) Ready To Feed | 0 | 0 | 0 | Powder | 37,748 | 0.0 | 0.0 | 27,900,862 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! | |
| 0.000 | ||||||||||||||
| IFF 0-3 months & IBP 1-3 months | Ready to feed | 65 | 0.0 | 0.0 | 48,074 | ERROR:#DIV/0! | $0.000 | $0.000 | $0.000 | ERROR:#DIV/0! | ||||
| (IFF) concentrate | 823 | 0 | 52 | 42,796 | 0.000 | |||||||||
| (IBP) concentrate | 388 | 0 | 3 | 1,164 | ||||||||||
| (IFF) powder | 870 | 0 | 10,124 | 8,807,880 | TOTAL MONTHLY NET PRICE | ERROR:#DIV/0! | ||||||||
| (IBP) powder | 435 | 0 | 1,382 | 601,170 | ||||||||||
| (IFF) ready-to-feed | 832 | 0 | 23 | 19,136 | ||||||||||
| (IBP) ready-to-feed | 384 | 0 | 1 | 384 |
| Age 4-5 months | ||||
| (IFF) concentrate | 896 | 0 | 26 | 23,296 |
| (IBP) concentrate | 460 | 0 | 2 | 920 |
| (IFF) powder | 960 | 0 | 5,283 | 5,071,680 |
| (IBP) powder | 522 | 0 | 754 | 393,588 |
| (IFF) ready-to-feed | 913 | 0 | 11 | 10,043 |
| (IBP) ready-to-feed | 474 | 0 | 1 | 474 |
| Age 6-11 months | ||||
| (IFF) concentrate | 630 | 0 | 75 | 47,250 |
| (IBP) concentrate | 315 | 0 | 5 | 1,575 |
| (IFF) powder | 696 | 0 | 17,672 | 12,299,712 |
| (IBP) powder | 384 | 0 | 1,655 | 635,520 |
| (IFF) ready-to-feed | 643 | 0 | 27 | 17,361 |
| (IBP) ready-to-feed | 338 | 0 | 2 | 676 |
| Notes: |
| *Column D is the average number of clients issued contract brand formula based on March 1, 2020 through February 28, 2021 data. |
| Columns G and J are the sums of the blue, pink and orange fields in Section I |
| Columns C, F, H, I, L, M are brought over from the Bid Sheet tab |
image1.png
File details come from the government source that posted it. Updated .