Daily profit / loss oil trucking

What I do is track daily truck hauls of oil with basic info: receipt number, date, number of barrels, location hauled from and delivered to, etc. I am trying to incorporate a daily profit/loss into these truck loads. The profit/loss amount will be based on the particular locations picked up from and delivered to, the number of barrels delivered, and the trucking company used. At the most basic, we will buy the oil at a price which is specific to the oil well, pay the trucking company based on which location they are going to and from, and we will sell the oil, which the price is specific to the location being delivered to. I am hoping to either add this to the existing pivot table, or maybe have to create a new one strictly for this. Anyone have experience with this or have any ideas? I have attached something similar to what I currently use.

Thanks!