How to buy the Best Formula for cheap – Formula Price Comparison Tool!

Ever tried shopping for your favorite brand of Formula in less than 20 minutes? Seems like an impossible task, isn’t it?

As if choosing the “right” formula for my baby wasn’t enough of a daunting task with a total of 87 options (yes, 87!) available in the market, once I have made the decision on what brand and type of Formula to purchase, I now had about 120 websites selling me the same product in different combinations (Powder/ Liquid Concentrate/ Ready to Feed… 23.2oz, 10oz, 4oz.. etc. etc. etc.). If I wanted to get the best value for the money I was paying, there was no easy way to compare them. Each product has a different count, some websites asked to pay for shipping, some had coupons with discounts, which made them as different as apples and spaceships.
I created this easy Excel sheet to compare apples to apples which would help me calculate PRICE PER FL. OZ. OF PREPARED FORMULA, which is what I really use to make my decision.


CLICK HERE TO DOWNLOAD THE EXCEL SPREADSHEET – MOST EFFICIENT CALCULATOR TO PURCHASE FORMULA!


  

Here’s a description of each of these columns so you know how to use the spreadsheet. The first time you use it, you may need to enter a lot of websites and combinations, but eventually, you will start seeing patterns and know which of the top 3 websites have the least expensive Formula on sale, so you will not need to enter so much data to compare.
HOW TO USE THIS WORKSHEET
Example
Store Enter Store Name FYI Amazon
Description Enter Product Name FYI Gerber Good Start Gentle Powder Infant Formula Value Pack, 27.8 Ounce, 4 Count
Type of Formula Powder/Liquid Concentrate/Ready to Feed? FYI Powder
Weblink Enter Website FYI Amazon
Coupon Code Enter Coupon Codes so you don’t have to remember them later! FYI Subscribe & Save 5%, 15% Off Coupon on first delivery
Notes Write your notes here FYI
Size (Oz.) Enter the size of the product per item (For ex: 23.2 oz per tub) Mandatory 27.8
Number of Items (cans/tubs/bottles) Enter the number of Bottles or Tubs per case/box (For ex: 4 Tubs per package) Mandatory 4
Prepared Formula Size Per Item (Oz) This will be usually written on the back of the product in the description. (For ex: One 23.2 oz Gerber powder makes 164oz formula) Mandatory 197
Total Prepared Formula Size (Oz) Autocalculated. Do not edit this cell. This gives you total size of the prepared formula. (For ex, if you buy 4 tubs of 23.2oz powder, each powder giving 164oz formula, you will have a total of 4×164=656oz of total prepared formula) Autocalculated 788
 Price Enter total price of the ENTIRE PACKAGE AND NOT EACH TUB/BOTTLE. Mandatory  $ 98.40
 Discount Enter the discount in Dollars or (=Price x % of Price) Mandatory  $ 19.68
 Shipping Enter Shipping Cost. Leave blank if you are buying at store. Mandatory  $ 0
 Tax Enter tax. If you do not know the exact amount, enter approx. state tax as per your state Mandatory  $ 6.15
 Total Autocalculated. Do not edit this cell. This is your total cost of ownership. Autocalculated  $ 84.87
 Price Per Oz. Autocalculated. Do not edit this cell. This number should be AS LOW AS POSSIBLE to get the best deal. Autocalculated  $ 0.11
FINAL STEP: Now SORT the Column L (PRICE PER OZ.) by clicking on the small triangle and clicking on “Sort Smallest to Largest”. When you are done, you should see a small arrow next to the triangle indicating that the sorting has been done.
NOW THE FIRST ITEM ON THE LIST IS YOUR BEST CHOICE – IT HAS THE LEAST PRICE PER Oz., WHICH MEANS YOU ARE PAYING LESS FOR MORE FORMULA!
CONGRATULATIONS, YOU’VE MADE A SMART CHOICE!

Note: Your best choice is always the FIRST ROW after you finish sorting.

Advertisements

3 thoughts on “How to buy the Best Formula for cheap – Formula Price Comparison Tool!

Drop a line here!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s