210000001676 - Schedule B - Pricing v2.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
Women, Infants, and Children Infant Formula Rebate Program
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 FormProduct Brand NameUnit Size
(oz.)Reconstituted Oz. per UnitWholesale Price per UnitRebate Bid
per UnitNet Cost per UnitPercent Rebate
Liquid Concentrate$0.000ERROR:#DIV/0!
Powder$0.000ERROR:#DIV/0!
Ready-to-Feed$0.000ERROR:#DIV/0!

Bid Calculation Sheet

MICHIGAN WIC PROGRAM
PRIMARY CONTRACT BRAND FORMULA INFORMATION
FORMULA BID EVALUATION WORKSHEET
Section ISection II
INFORMATION WORKSHEETBID CALCULATION SHEET
ABCDEFGHIJKLMNO
Age Group /
Formula by FormMonthly Maximum Reconstituted OuncesReconstituted Ounces per Unit (Can of Formula)Average Number of Infants *Total Monthly Reconstituted OuncesPhysical Form
Brand NameTotal Monthly Infants
(sum of infants by form under Col. D)Unit SizeReconstituted Oz. Per UnitTotal Reconstituted Monthly Ounces (sum of ounces by form under Col. E)Total Monthly Units
(Col J/Col I)Wholesale Price Per UnitRebate Per UnitNet Price per Unit (Col L - Col M)Net Cost

(Col K * Col N)

0
IBP Age 0 months
(IBP) Concentrate000Concentrate1630.00.0117,001ERROR:#DIV/0!$0.000$0.000$0.000ERROR:#DIV/0!
(IBP) powder104087891,3120.000
(IBP) Ready To Feed000Powder37,7480.00.027,900,862ERROR:#DIV/0!$0.000$0.000$0.000ERROR:#DIV/0!
0.000
IFF 0-3 months & IBP 1-3 monthsReady to feed650.00.048,074ERROR:#DIV/0!$0.000$0.000$0.000ERROR:#DIV/0!
(IFF) concentrate82305242,7960.000
(IBP) concentrate388031,164
(IFF) powder870010,1248,807,880TOTAL MONTHLY NET PRICEERROR:#DIV/0!
(IBP) powder43501,382601,170
(IFF) ready-to-feed83202319,136
(IBP) ready-to-feed38401384
Age 4-5 months
(IFF) concentrate89602623,296
(IBP) concentrate46002920
(IFF) powder96005,2835,071,680
(IBP) powder5220754393,588
(IFF) ready-to-feed91301110,043
(IBP) ready-to-feed47401474
Age 6-11 months
(IFF) concentrate63007547,250
(IBP) concentrate315051,575
(IFF) powder696017,67212,299,712
(IBP) powder38401,655635,520
(IFF) ready-to-feed64302717,361
(IBP) ready-to-feed33802676
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 .