Here are my Price Book numbers with the Week 3 data included.
Ground Beef...2.28/3.69 3.79/3.99 2.79/2.99
Chuck Roast....3.99/3.99 2.99/3.99 3.79/3.79
Hot Dogs....4.99/5.99 4.99/5.99 4.99/3.00
Pork....3.99/3.00 3.99/2.99 3.49/2.99
Bacon....2.98/3.50 3.99/3.50 3.99/3.00
Chicken Breast....2.99/3.09 2.99/3.49 2.99/3.99
Chicken Whole.... .78/1.69 1.39/1.89 1.59/1.49
Salmon....10.00/7.99 0.00/7.99 9.99/7.99
Cheese....1.77/2.99 2.00/2.00 1.75/2.00
Butter.....3.00/3.50 3.49/3.98 2.50/2.50
Eggs....1.93/1.50 1.79/1.89 1.83/1.53
Carrots.... .90/1.00 .75/1.29 .90/1.69
Potatoes....1.48/2.50 2.99/2.99 1.50/2.00
Celery.....1.69/2.59 1.99/1.89 2.99/1.50
Onion..... .49/.75 1.69/1.00 .59/1.69
Salad Greens....2.50/1.95 2.50/1.85 2.50/1.85
Pasta..... .88/1.00 1.00/1.00 1.00/1.00
Spaghetti Sauce.... .88/1.00 1.33/1.25 1.50/2.00
Coffee....5.65 lb/5.12 lb 5.65 lb/4.16 lb (4.00)5.65/4.85*
Soup Tomato...1.05/.75 1.05/1.00 .50/.69
Soup Cream....1.00/.75 1.29/1.39 .99/.75
Flour.....2.19/2.19 2.19/2.19 2.00/2.19
Sugar.....2.69/2.69 2.69/2.69 2.50/2.69
Brown Sugar...1.89/1.69 1.89/1.69 1.89/1.69
Honey.....4.00 lb/3.45 lb 4.00 lb/3.45 lb 4.00 lb/3.32 lb
Deli Ham...5.99/7.99 4.99/5.99 4.99/7.99
Deli Provolone...7.99/8.99 4.99/8.99 5.99/8.99
Frozen Pizza...4.49/4.99 5.00/3.33 5.00/3.33
Ice Cream...3.00/3.00 2.50/3.00 3.50/3.00
Frozen Broccoli...1.88/1.50 2.19/2.00 2.09/1.25
Soda....4.99/4.00 4.00/4.00 3.66/3.25
Chips....3.00/3.00 3.00/2.50 2.15/2.15
*I have to make a special note on the coffee prices at Store #1 this week. The best price was still $5.65, however, they had some bags of coffee in the clearance bin @ $3 for a 12oz. bag, which came out to $4 lb.(and I bought some). As this was a clearance special/a small quantity and not a regular sale item available at all their stores, I still used the $5.65 lb. price for my data. Using this unique special price/opportunity only would skew the cycle prices for this item in this store's week and not have given me the real picture on the pricing trend.
Having half our data in the book now, let's take a look at our numbers.
Looking at the items you put in your book, can you see that some of them are quite volatile in terms of prices and how much they vary from week to week?
Take the Deli Dept. cheese on my list--in 3 weeks time it's been a low of $4.99 to a high of 8.99. That's a $4 difference for the same item!
If you are buying items when they are higher/highest in the sales cycle, you are spending money you really shouldn't have to if you just pay attention and time your purchases right.
Can you also see that some of the items' prices seem not to change(go on sale)at all or only infrequently?
My baking supplies--flour, sugars, honey prices haven't varied at all. The flour and reg. sugar at Store #1 went on sale for .19¢ less last week and the honey at Store #2 had a .13¢ price reduction the same week. I'll hazard a guess that these items maintain their regular prices for the next 3 weeks.
You may also notice that some of the same items at your 2 different stores go on sale during the same week. Stores tend to keep an eye on what the other one is up to and will put the same types of foods on sale as their competition.
Another trend is the same name brands will go on sale simultaneously at both of your different stores. This is due to special pricing and deals the manufacturers run to their clients, the grocery stores. This trend will be very noticeable starting this week, Week #4 of our price cycle. Party, Snacking and Finger Foods are being pushed in the Week leading up to Super Bowl. You will notice the same items featured in the different grocery store chains at identical(or almost identical)special pricing.
Another trend you can start to notice with this many weeks charted is how one of your stores will usually be lower on the regular prices on items than the other store. Neither of my stores have put the brown sugar on sale in the last 3 weeks, and Store #2 always has a lower regular price than Store #1. If this trend holds true for the next 3 weeks, I can then make a note that if I need brown sugar and no stores have it on sale, I should always buy it at Store #2, because this automatically saves me .20¢ per bag.
Now let's make a hypothetical shopping list up.....
2 x 5lb. chickens
3 x 2lb. ground beef
1 x 1lb. salmon
1 x dzn eggs
2 x bags of cheese
1 x 1lb. butter
1 x celery
1 x 2lb. onions
2 x salad greens
1 x 1lb coffee
2 x frozen broccoli
1 x potato chips
If we had bought these items at the store in the week when the prices were highest, we would have paid $77.10 for all.
If we had bought these items at the store in the week when the prices were lowest, we would have paid $41.96 for all.
That's a difference of $35.14 for one shopping list of items!
If we were to extrapolate this out and say we purchased this shopping list of items every 2 weeks for a year, if we always bought at the highest priced week for each item, we would overspend in a year to the tune of......$913.64.
This should make it crystal clear to anyone how the timing of your food purchases can either save you or cost you money.
Onward to Week #4.......