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