Help, what formula to use for percentage...

Posted on 2016-10-27
Last Modified: 2016-12-01
I am unsure the best way to figure this out and would be most grateful for any assistance.

I have a logistics company and im needing the answer below is my example

We are contracted with several thousand truckload carriers to haul full truckload freight for us.

Moved 20 truckloads within 10 days
Using 15 different carrier companies
From Atlanta Ga to columbus oh
The average we paid $700
Lowest we paid a carrier $600
Highest $800

Our software tool doesnt give us a confidence meter of sort( what is the percentage that we will find carriers in the next 15 days to do at leaat around what we paid on average the last 15 days $700? The problem is we can run our past costs and determine from that data what we believe we're going to pay but it would be nice to have a percentage relating to our chances that will be successful using our average pay and still getting carriers ar the average cost. Make Sense?

I figured since we had used several different carriers and all happy with the average it bettered our chances the rate would work easier than if someone moved 20 loads and hired only 3 different carriers (in our industry that shows the average rate wasnt enough because only 3 different carriers used when most prefer several different carriers be used)

please let me know what additional information i can give.

 and the average we paid a carrier
Question by:jarrod marinello
LVL 27

Expert Comment

ID: 41862782
No sure that anything makes sense.

Why do contract with several thousand carriers when you only use 15?
How do you hire a carrier?  Do you solicit bids or request quotations?
What is a truckload?  How many packages?  How much weight?
What sort of software are you using?
What are you shipping?
How far ahead can you plan shipments?
Who owns and loads the trailers?

I would think you would get the best results by soliciting bids from a single carrier for a well defined amount of shipping over the course of a year.
If you can't do that, you may have to live with fluctuating market conditions.
LVL 23

Expert Comment

by:Brian B
ID: 41862945
Let me move the words around in your question and you can tell us if this still makes sense...

"We moved 20 truckloads From Atlanta, GA to Columbus, OH within 10 days using 15 different carrier companies.
The average we paid $700
Lowest we paid a carrier $600
Highest $800"

So knowing the above information and obviously what you paid each carrier, you want to predict how much the next shipment will cost? And also the chances that prediction will be right? You are right that is a statistical calculation called "confidence".

However that is assuming that I am right. I would like to know if I understand your problem before we take too much time trying to answer.

Author Comment

by:jarrod marinello
ID: 41863017
thanks so much for your reply. Almost. We have a analysis rate tool that we can put in a particular lane to pull up if and how many loads moved for past 15 days then it gives us the average rate we paid. what we would likw to have to go with our rate tool is a tool that gives us a probability the next loas that moves in the lane will be able to move at or around the average. here some figures for example. monday we had 2 loads, tues we had 3, and wed had 1 load all for same freight lane atlanta to columbus oh we used 4 different carriers and average we paid $750. so if i run this lane search it shows up $750 average and we want to add a spot on the same screen that tells us chances will be able to hire a carrier for loads we have monday for around $750 average. is it possible to do this?
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 27

Accepted Solution

d-glitch earned 250 total points
ID: 41863220
I don't think so.  You are asking to predict the future.
How do your carriers decide on a price?  You should talk to them.

If you have been doing this for a while, you should have a lot of historical data.  Look at it, and see if you can find a trend.  Is there a price spike around Christmas?  How important is the price of fuel?
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
ID: 41872503
Rather than using standard Mean average (Total sum divided by Count of entries) it might be worth also looking at Mode and Median averages.

Mode - returns the most frequent value from a range of values
Median - returns the mid point between highest and lowest, if there were 9 values in the list it would be the 5th when sorted in numerical order. Where there is an even number of values, it is the value midway between the middle two values eg with 10 values, median is midway between values 5 & 6 when sorted.

If your Mode is higher than the Mean average it means the most frequent value is above average. This could suggest that the likelihood of matching the Mean average in future is lower as it would suggest that prices are increasing.
LVL 14

Expert Comment

ID: 41908411
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

-- d-glitch (https:#a41863220)
-- Rob Henson (https:#a41872503)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword (May 2015) This web page has appeared at Google.  It's definitely worth considering! How to Know You are Making a Difference at EE In August, 2013, one …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question