I had planned over my spring break a few weeks ago to compare prices on products we often buy at different stores across the city. And I mostly did it. I went to: Cub, Target, Rainbow, Whole Foods, Trader Joe’s and Mississippi Market, the co-op.
I made a worksheet in Excel with the names of each product and the price at each store. I wasn’t too picky about brands, I just compared the cheapest brand that met my requirements (e.g. organic, no-salt added, etc.).
Not all stores carried everything I wanted, so I just left those spaces blank. Phil did some analysis for me afterwards and added the categories and the priorities. I wanted to make sure one store wasn’t “winning” on cheapest just because it had the cheapest of the less frequently purchased items.