I dispatch for a trucking company. I'm trying to find a formula to work out the percentage difference between loaded miles and empty miles. For example: One driver drives 200 miles. 150 loaded and 50 empty. That's 75% loaded. I need a formula to figure out that same situation but with numbers that aren't quite so round. I tried $$\left(\frac{x-y}{\frac{x+y}{2}}\right)\cdot 100$$ but it didn't work out the way I'd hoped. Any help would be great. Thanks.
Asked
Active
Viewed 1,326 times
2 Answers
1
Let $L=$Loaded Miles and $U=$Unloaded Miles.
The percentage of loaded to unloaded would be $$100 \times \frac{L}{U+L}$$
For example if (as in your example) $L=150, U=50$ then percentage of loaded miles is \begin{eqnarray} 100 \times \frac{150}{150+50} &=& 100 \times \frac{150}{200} \\ &=& 100 \times 0.75 \\ &=& 75\% \end{eqnarray} This works on the premise you know at least two values from Total Miles, $U$ and $L$.
Autolatry
- 3,016
- 1
- 16
- 16
-
Thanks. I can't believe I didn't see that. I feel like an idiot now. – tallybear Jul 20 '15 at 15:40
-
Nah don't worry some of the most simplest ideas trip us all up dude. All the best. – Autolatry Jul 20 '15 at 15:48
0
I'm not sure you're asking this. But anyways: Let x represent the loaded miles, y the empty miles. Then $$\frac{100y}{(x+y)}=z,$$ where $z$ is the percentage.
ZenoCosini
- 780