Tips and Tricks Tuesdays: Make Your Own Price Book

Make Your Own Price Book

20130227-142246.jpg

Do you like the feeling when you know you actually saved money during a sale rather than just buying an item during a sale and thinking you saved money? I know I do. (Now I sound like a bad infomercial) But there is a way to know exactly when you are getting a deal on all sorts of products. By creating your own Price Book, you can find the average price of the desired product at all of the major retailers and find out which really is a sale.

For example: (The price of Paper Towels at different retailers)

*Wal-Mart: $1.89
*Walgreens: $1.97
*Target: $1.79
*Cub: $1.99

Knowing that the lowest price of towels is 1.79 when they are not on sale should tell you that even if Cub’s Everyday brand paper towels go on sale from 1.99 to 1.79, it’s still not a sale because you could have purchased the paper towels at Target for 1.79 without a sale.

Next, find out all of the sale prices on the paper towels at each of the retail stores and find out what the average sale price is.

(Sale price for Paper Towels at different retailers)

*Wal-Mart – $1.29
*Walgreen – $1.39
*Target – $.99
*Cub – $1.38

(Average sale price = $1.26)

Now that you have found the target price you will pay for the paper towels, it is time to find out how often this item goes on sale. When you have found out the sales cycle for the paper towels (let’s say 5 weeks) when the sale hits, stock up on the item. Get as much as you think you would consume in the 5 week period until the next sale. This way when you run out of paper towels, there should be a sale where you can stock up for another 5 weeks until the next sale.

When creating a Price Book you will have to be organized, especially when it comes to a grocery list which can sometimes be longer than Santa’s naughty list. One way to keep organized is to create a Price Book from Microsoft Excel. Here is a basic template can be used to help jumpstart your very own Price Book:

1/10/2013 Walgreens SB Paper Towels 1 Roll (70 sheets) Reg. Price $1.97 Sale Price $1.29
1/8/2013 Wal-Mart SB Paper Towels 1 Roll (70 sheets) Reg. Price $1.89 Sale Price $1.39
1/15/2013 Target SB Paper Towels 1 Roll (70 sheets) Reg. Price $1.79 Sale Price $.99
1/17/2013 Cub SB Paper Towels 1 Roll (70 sheets) Reg. Price $1.99 Sale Price $1.38

***SB is abbreviation for Store Brand.

While using a Price Book, you will be surprised to see how much money you can save. You will also see when a so called “sale” really isn’t a sale at all. Give it a shot. It may take some time to develop, but this can be a helpful tool that could save you a lot of money. Happy sale hunting!

Advertisements

3 thoughts on “Tips and Tricks Tuesdays: Make Your Own Price Book

  1. I love this! Except I feel like it would take me forever to make my own. When you complete yours, can I buy a copy off you? 😉 I’m serious!! I would LOVE to know a target price for what I’m buying and what actually is a good price for things but I just can’t get myself to do it!

  2. I used to do this but haven’t in two years. Want to start up again. That os why i wrote this post. I might use an app to simplify the process. But Kimber also used to do this. I can ask her if she still does

Leave a Reply

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