Things You'll Need:
- Spreadsheet
-
Step 1
Create a spreadsheet of items bought weekly. A spreadsheet makes it easy to look up an item's price. A spreadsheet to compare grocery prices should have a column for the items, plus columns for the unit price at each store the consumer shops at. Once the spreadsheet is organized and filled out, the consumer will quickly be able to determine which store has the best price.
-
Step 2
Organize the spreadsheet. Break down the items into categories, such as dairy and dry goods. Or, put the spreadsheet in alphabetical order. For the best organization, place the items into categories and then alphabetical order.
-
Step 3
Check unit prices at local stores and write them on the spreadsheet. Most grocery stores will list a unit price on the sales tag. For example, a gallon of milk may cost $0.03 per ounce. It will take a bit of time to completely fill out a spreadsheet, but the savings will be worth it. A spreadsheet can be printed out or carried with a consumer on a PDA or cell phone.
-
Step 4
Do the math on unit prices. Not all unit prices will be equal. Some stores may list a gallon of milk at a unit price per ounce, while other stores use a per quart unit price. Some stores don't even list a unit price. It will take a bit of math on the spreadsheet, but it will be worth it. Just make sure to fill out the main copy of the spreadsheet with the completed unit prices.
-
Step 5
Compare the prices. A quick glance at the spreadsheet will give the consumer an idea of which store has the best everyday price. It's important to take sales into account, though. With a bit more math, consumers can compare sales prices to everyday unit prices to determine which store has the best price.
