210000001676 - Schedule B - Pricing.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 for milk-based infant formula in three physical forms: liquid concentrate, powder, and ready-to-feed formats. The pricing schedule requires contractors to enter manufacturer name, product brand name, unit size in ounces, reconstituted ounces per unit, wholesale price per unit, and rebate per unit for each formula type. The bid evaluation worksheet projects monthly consumption based on historical data from March 1, 2020 through February 28, 2021, with calculations spanning multiple age groups including infants from birth through eleven months, with separate tracking for IBP (Infant Based Products) and IFF (Infant Formula Formulations) categories.

All pricing must be submitted in a modifiable format such as Microsoft Excel or Word, with an optional non-modifiable PDF version permitted. Wholesale prices and rebates per unit must be submitted with three decimal places, and all costs must be included in the pricing, such as shipping, handling, per-piece pricing, and palletizing charges. The bid calculation sheet automatically computes net costs by subtracting the rebate per unit from the wholesale price per unit and multiplying by projected monthly unit volumes. Failure to complete the pricing schedule as requested may result in proposal disqualification. By submitting a proposal, contractors certify that prices were developed independently without consultation or agreement with other contractors.

View the file

Other files

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 receiving 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 .