My husband and I Were doing this calculations by hand, it was a bless that we found this spreadsheet/excel add-in.
We can not thank them enough for taking the time to simplify all these work in a spreadsheet form.
You get link access to DAT data current prices per mile for Van, Reefer, Flatbed, Industry Trend lines, etc.
This is their website below, I hope it helps.
Screen Shots
Home