I gave up on couponing years ago because of all the processed food, but now I am going to revisit it once again with the food prices going up the way they are. My first step is this – figuring out, and then addressing, the false economics of couponing. So today I’ll show you how to make a gas map so you can see how much your trips to various stores actually COSTS.
The Gas Map.
This especially applies to anyone who lives in the sticks like me. If it takes you LOTS OF GAS MONEY to drive to these stores, you must assess if the deal is actually worth taking advantage of! So here is how you figure that out. I’ve even created a handy little spreadsheet for you to use to calculate this (screenshot on the right, click the image to make it big).
- Download the spreadsheet here.
- Make a list of all the stores you shop at or would be willing to potentially shop at.
- Now, expand that list into “trips” by writing down all the potential trips you could make from one store to the next. Here’s a picture of mine:
- Now, go to Google Maps. Find the first store in Google Maps, and then pretend to get directions from your house to that store.
- Click “add destination” to add another store, and repeat until all your stores are added. It may also ask you “Did you mean:” and ask you to select the store. Go ahead and select whatever it says is the store. In the image it asks about BECU – Bonney Lake Safeway. I clicked that because BECU is the credit union inside Safeway, so it will give me the correct directions.
- Once you have each store selected, if you scroll down a bit on the left side, you will see how it not only gives you directions but ALSO tells you how many miles are between each store.
- Rearrange the stores by clicking and dragging them to new spots so you can get the mileage between each store – potential trip (referring to the list you made in step 3). Write down all the mileages or notate them in the spreadsheet in the correct column. (sorry the screenshot didn’t capture this – my mouse cursor turned into a hand and I was able to drag the stores to reorder them… you get the idea!)
- When you know exactly how many miles are between each store you could potentially go to, you just need to figure out what it costs. If you happen to know your gas mileage, great. I didn’t, so I went to http://www.fueleconomy.gov and looked up my truck. I’ll track my next tank of gas so I get a better picture, but this is a close estimate. Also you need to know the average price per gallon of gas. Input these numbers into the highlighted spots in the spreadsheet.
- Now just hit tab and it will calculate exactly how much money it costs you to go from one store to the next, and from your home to each store! I’ve left lots of room in the spreadsheet so you can figure out as many stores as you want.
Personally, I found it helpful to actually draw out a pseudo map on a piece of paper because I am a visual person. Lucky for me, since I live out in the sticks everything is on one main highway! And the store I go to the most (Winco) is the furthest one away, which means all of the other stores are on the way.
So there you have it. As you can see, it costs me about $6.42 in gas round-trip (remember to calculate your gas home, too!) to go grocery shopping at Winco. Kinda freaky looking there in black and white. The closest grocery store is Safeway which costs me $4.72. So if I found something super fabulous there, even if it is FREE, I need to remember that it still costs me $4.72 just to get there and back. Keep this spreadsheet on hand – you can update it for different vehicles and if gas prices change, or if they put in a new store.
Next post in the series – What we pay for coupons…