Grocery Price Book
Category Item Brand Store Price Size Unit $/unit Best Date Notes
$/unit
Dairy / Fridge Cheddar Cheese Tillamook Walmart 2.87 1 lb 2.870 2.400 3/5/14
Produce Apples Smith's 1.05 1 lb 1.050 0.750 9/15/14
Produce Broccoli Walmart 2.20 1 lb 2.200 1.500 8/1/14
Breakfast Lucky Charms General Mills Walmart 3.88 24 oz 0.162
Breakfast Marshmallow Mateys Malt-O-Meal Walmart 4.48 25.1 oz 0.178
Breakfast Frosted Bites Market Pantry Target 3.14 20.5 oz 0.153
Dairy / Fridge 1% Milk Albertsons Walmart 1.99 1 gal 1.990
Dairy / Fridge 1% Milk Great Value Smith's 2.10 1 gal 2.100
Dairy / Fridge 1% Milk Kroger Albertsons 2.80 1 gal 2.800
Bread / Bakery Multi-Grain L'oven Fresh Smith's 1.99 24 oz 0.083
Bread / Bakery Multi-Grain Trader Joe's Trader Joe's 2.79 24 oz 0.116
Bread / Bakery Multi-Grain Nature's Own Albertsons 2.39 24 oz 0.100
Canned Green Beans Happy Harvest Walmart 0.89 14.5 oz 0.061
Canned Green Beans Kroger Smith's 0.79 14.5 oz 0.054
Canned Green Beans Trader Joe's Trader Joe's 0.59 14.5 oz 0.041
Canned Green Beans Great Value Albertsons 0.69 14.5 oz 0.048
-
-
-
-
-
-
-
-
-
-
-
-
-
-
http://www.vertex42.com/ExcelTemplates/grocery-price-book.html Grocery Price Book Template © 2015 by Vertex42.com
Category Item Brand Store Price Size Unit $/unit Best Date Notes
$/unit
-
http://www.vertex42.com/ExcelTemplates/grocery-price-book.html Grocery Price Book Template © 2015 by Vertex42.com
Baby Bread / Bakery Breakfast Canned Condiments Dairy / Fridge
Baby Food Bagels Cold Cereal Applesauce Croutons Biscuits
Diapers Bread Oatmeal Beans Honey Butter
Formula Cake Creamed Wheat Chili Jam / Jelly Cheese
Rash Cream Cookies Pancake Mix Fruits Ketchup Cookie Dough
Wipes Dinner Rolls Mushrooms Mayonnaise Cream Cheese
Donuts Olives Mustard Dips
French Bread Soup Peanut Butter Eggs
Hamburger Buns Tomato Sauce Pickles Half & Half
Hot Dog Buns Tuna Salad Dressing Milk
Muffins Vegetables Salsa Sour Cream
Pastries Whip Cream
Pie Yogurt
Pita Bread
Tortillas
Drinks Dry / Baking Frozen Household Meat Paper / Plastic
Water Baking Powder Chicken Batteries Bacon Aluminum Foil
Juice Baking Soda Desserts Bleach Beef / Steak Bags
Soda Bread Crumbs Dinners Cards Chicken Coffee Filters
Sports Drinks Brownie Mix Fish Charcoal Deli Meat Cups
Coffee Cake Mix Fruits Detergent Fish Garbage Bags
Tea Canned Milk Ice Dish Soap Ground Beef Napkins
Chocolate Chips Ice Cream Dishwasher SoapHam Paper Towels
Cocoa Ice Pops Fabric Softener Hot Dogs Plastic Wrap
Cornmeal Juice Glass Cleaner Pork Plates
Cornstarch Lasagna Light Bulbs Sausage Tissues
Flour Pie Rags Turkey Toilet Paper
Food Coloring Pizza Sponges Utensils
Frosting Vegetables Vacuum Bags Wax Paper
Muffin Mix Waffles
Oatmeal
Pie Crust
Shortening
Sugar (brown)
Sugar (powder)
Sugar (white)
Vanilla
Yeast
Pasta / Rice Personal Pet Produce Sauces / Oils Snacks
Couscous Conditioner Pet Food Apples Vegetable Oil Candy
Hamburger HelpeCotton Products Cat Litter Avocados Soy Sauce Cookies
Lasagna Deodorant Treats Bananas Olive Oil Crackers
Mac & Cheese Feminine Berries Vinegar Dip / Salsa
Macaroni Floss Broccoli BBQ Sauce Dried Fruits
Noodle Mixes Hair Spray Carrots Hot Sauce Fruit Snacks
Ramen Lip Balm Celery Spaghetti Sauce Graham Crackers
Rice (brown) Lotion Cucumbers Syrup Granola Bars
Rice (white) Makeup Garlic Nuts / Seeds
Rice Mixes Mouthwash Grapefruit Popcorn
Spaghetti Pain Relievers Grapes Potato Chips
Razor Blades Lemons/Limes Pretzels
Shampoo Lettuce Pudding
Shaving Cream Melons Raisins
Soap Mushrooms Tortilla Chips
Sunscreen Onions
Toothbrush Oranges
Toothpaste Peppers
Potatoes
Squash/Zucchini
Tomatoes
Spices
Salt
Pepper
Cinnamon
am Crackers
STORES UNITS BRANDS This worksheets allows you to cus
Albertsons lb store lists used in the some of the drop-
Costco oz Kirkland
Food 4 Less pcs Nabisco
Safeway kg
Sam's Club g
Smith's L
Target mL
Trader Joe's
Walmart
Whole Foods
sheets allows you to customizable the
in the some of the drop-down boxes.
Grocery Price Calculator
Item Price
Quantity Price
12 for $4.99
Units per Item
8 total units (oz, lb, kg, L, etc.)
Item Price Unit Price
Price (no coupon) $0.416 $0.052
Discount Coupon (optional)
$ %
0.5 or 0%
When You Buy…
4 (quantity)
Item Price Unit Price
With Coupon $0.291 $0.036
This worksheet is for helping you calculate unit prices on items that
don't have a unit price listed.
Item Price - This is the advertised sale price.
For example, the price may be listed as 10 for $10.00. This calculator
assumes that you can by fewer than 10 and still pay $1.00 for each
item.
Units per Item - Enter the total number of units in one item.
For example, enter 5 to calculate the unit price of a 5 pound bag of
flour as $ / lb.
Discount - Enter a % or dollar discount, but not both.
Some coupons make you purchase more than one item in order to
get your discount. This is what the "When You Buy…" field is for.
For example, the coupon may say "$0.75 off 2" or "Get $0.75 off
when you buy 2". This is assumed to mean that you must buy 2 items
in order to get a total discount of $0.75.
