Pattern Finding for Pricing - Formula

Hi,
I work for a trucking company and we are in the process of updating our prices due to increased costs of business.

I have a previous price spreadsheet which was created before I started working. The price is based upon how many miles are traveled. Each mile increment reflects a different per mile price. I would like to analyze the pattern with these numbers.

What is the pattern associated with those numbers based upon the miles?

Once I find that pattern I can use it to create our new pricing sheet.

Cost Sheet.xlsx

The original prices are found in grey and the adjusted are in yellow. I have determined our cost for each and highlighted it in green.


Any help is greatly appreciated

Need to know based on your table, how you arrived at the Adj. Percent Profit, and Total Cost fields.

Pete