It's a Team's Life
Spreadsheets - Pilot
This is NOT SO... I do enjoy spreadsheets, but my spreadsheets are really pretty simple compared to the spreadsheet guru’s out there.
One of my spreadsheets as many of you can imagine is on fuel mileage and I have incorporated into that spreadsheet how much we save on fuel with our fuel discounts. This is easy to keep I have a column that tells cash price of ticket and total amount of fuel on the ticket. Next I go online and sign into our T-Chek account and find what we actually paid for fuel and my spreadsheet calculates the difference. Each month I can easily see how much our discounts added up to.
Another column on the spreadsheet is for fuel tax, as we like to know what our fuel actually cost us and knowing this figure often influences us on where we buy fuel. We want to buy fuel the cheapest and in order to know where the cheapest fuel is we have to take out the taxes. This took me down a different path then I was headed...
Ok to get back on track we used to get a .05 discount off of the price of fuel at the Pilots and then also the Flying J's once they were purchased. With my spreadsheet this was easy to track with another column to see our discount.
Using the spreadsheet it is easy to see that we are getting the discount that we are expecting and also to see how much we save by using these fuel stops. The discounts are not always cheaper then a neighboring fuel stop and price watching is always a must. We are also cognizant of the surrounding prices and sometimes it is cheaper to cross the street and buy fuel.
I have found over the year that we are the ones that watch our discounts, as no one else will.