Price Book and Spending Plan Files Now Available

Last month I talked about how I put my price book together. At the time I wanted to share the file but wasn’t able to find a host for ir. Now I can share it with you guys thanks to Google. I am also sharing a spending plan/budget sheet that I came across a few years ago. It was originally shared by Jeff Opdyke from the column “Love and Money” in the WSJ. I really like that he calls it a spending plan not a budget and it has a lot of categories to help you plan your expenditures. I hope you find both of them useful. You can find them on the right side bar.

Oh! Finally, if you scroll all the way to the last worksheet in my price book you can take a peak at my obsessive-compulsive diaper stash inventory. Gosh! sometimes I am such an accountant!

Rely on Automatic Savings for Easy Saving

Saving is like trying to lose weight: we have the best intentions to do it but not usually the willpower. That’s why I love automatic investing. It’s like no-brainer saving. When I first introduced it to my husband he was worried that we were not going to be able to afford sending $25 to our savings account every pay period. But did he even notice that it had been already two pay periods since I had started doing it? No! And that’s one of the reasons I love using it.

  • Automatic investing is convenient: The money is taken out before I even get my hands on it. So I never count it towards my budget.
  • It also helps me stay consistent with my savings commitment. Because my budget has been adjusted downwards, I am not tempted to spend the money now and send in extra next time to make up for not saving this one time. But that time never comes.
  • It can also help you save more. Once you have determined that you CAN live without those $25 every paycheck, then you start thinking about what you need to tweak this time in order to be able to do without another $25.

Whether it’s savings towards an emergency fund, a vacation, Christmas gifts, or retirement, automatic investing makes it easier for you to be able to reach these goals. Now, if someone could come up with a way to lose weight automatically. Then we would be set.

Feed your family of 4 for 6 full days for $66

As my own personal challenge I took it upon myself to show you a real life example of how meal planning and shopping around your grocery store’s sales fliers can help you cut back on your food expenses. To keep it simple, I used the sales flier from only one of the grocery stores around me. Therefore my assumptions are: shopping at one grocery store, meal planning out of what they have on sale and I have meal planned for a family of four (two adults and two children over 6). So here it goes:

Breakfast items:
1 Gallon of milk $2.5 (16 servings)
2 boxes cold cereal $4.5 (16 servings)
1 dozen eggs $0.99 (4 meals)
Sausage links $1.00 (8 onz or 4 servings)
Bread for french toast, plus eggs and milk from above, breakfast day 6

Lunches
1 lb sliced turkey $3.99
8 ounces sliced cheese $2.65
2 loafs of bread $1.98 (ingredients above should make 8 sandwiches or 4 school lunches for children)
1 jar peanut butter (for lunch on the 5th day) $2.00
4 cans progresso soup $4.00 (2 days worth work lunches for adults)
Lunch day 6:
- 1 package beef franks $3.00
-1 6-count bag hotdog buns $1.50
- 2 lbs potatoes $1.18 for potato salad

Dinners
Day one: Shepherd’s pie (makes 6 servings, leftover lunch for adults)
-1 lb ground beef $1.88
-1 bag mixed frozen vegetables $1.00
-Use of second lb of potatoes bought for lunch Day 6
- 1 package gravy mix $0.5

Day two: Chili
-1 lb ground beef $1.88
- 32 ounce can crushed tomatoes $1.50
- 1 lb green peppers $0.99
- 1 16 ounce can red kidney beans $0.75

Day three: Lasagna (makes 6 servings, leftover lunch for adults)
-1 lb ground beef $1.88
-1 8 ounce bag mozzarella $1.80
- 1 15 ounce tub ricotta $2.00
- 1 box lasagna noodles $1.25
- 1 26 ounce jar pasta sauce $1.00

Day four: Chicken quesadillas
-1 bag tortilla wraps $1.45
- 1 16 ounce jar salsa $1.75
- 1 lb boneless skinless chicken breasts $1.99
- 1 8 ounce bag colby cheese $1.80

Day five: Peanut butter/soy sauce noodles and chicken stir fry (makes 6 meals, leftover lunch for adults)
- 1 lb thin spaghetti $1.00
- 1 lb b/s chicken breasts $1.99
- 1 bag frozen stirfry vegetable mix $1.00

Day six: Chicken mushroom casserole
- 1 lb b/s chicken breast $1.99
- 8 ounces white button mushrooms $1.00
- 1 can condensed cream of mushrooms $1.00
-Rice from your pantry

3 lbs of apples $2.67
3 lbs pears $2.67

Total:$66.03 plus tax

Many things could be different in this example. There are quite a few items that you might be able to find cheaper if you shopped around. But I wanted to prove to those that don’t have time to be driving around hunting for better deals that it could be done if you take your time to plan. I also added quite a few convenience items because I wanted to show a menu that offered busy families time efficiencies.

View here the shopping list I created at the grocery store’s website.

How I put together my own price book

A price book is an invaluable tool for anybody wanting to cut down on grocery expenses or just wanting to make the most of their money. The purpose of the price book is not only to record prices but keep track of sales in order to be able to identify when you are getting a great deal instead of just an OK one. In the past I have relied on my own memory to keep track of sale prices for items I am more likely to stock up on, or just items that I feel have the most impact on my grocery budget.

When I decided to finally put together a price book, I chose to track prices of things that I usually stock up on, or things that I buy often. So for example, I have meat (ground beef, turkey and chicken breast), toiletries (diapers, wipes, toilet paper), household cleaning items (paper towels, cleaning pads, laundry detergent, dish washing liquid) and other items such as soda. These were the things in my budget that I thought were worth looking into. For other grocery items that I don’t buy often like peanut butter, or ketchup, rice, I find out where I can buy it cheaper and then get it there.

I am accountant and as such I have a great affinity to using Excel, so I decided to use it to keep my price records. I have different tabs for the different products. For every item I have: Date (of sale), store name, brand, product size, price and the unit price. I have also added an additional column at the end, if for a certain product I have manufacturer’s coupons available. I have it as an add on because I may not have that coupon available every time I decide to buy so I don’t want it to bias the rest of my records. I suggest you keep track of prices for every product and every brand you will consider using or are available to you. I started recording prices of items at the stores I shop at: local grocery stores, Sam’s, Costco, Target and Walmart.

I found that with things like paper towel, or toilet papers you have to find a common denominator to make comparisons effective. Manufacturers have found ways to confuse you with the way they market their products in different outlets. For example, toilet paper is sold as: mega, jumbo, big, double and regular rolls. So you need to bring it down to how much each sheet costs to be able to make a fair comparison. I have laundry detergent down to cost per load and dish washing liquid to Oz if liquid or loads if using tabs or powdered.

I guess it might seem overwhelming at first but it really wasn’t. It took me one visit to each store with a notepad on hand and the list of the items I wanted to track. Now that I have it set up, all I need to do is look at the weekly sale circulars and see if any advertised sale beats what I have recorded in my price book. If I find a better sale, I record it because I want to identify if those sales are cyclical. So maintenance is quite easy.

I have found having a price book a great tool, because it has armed me with facts and information that has allowed me to make better purchasing decisions.