Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Help, what formula to use for percentage...

Posted on 2016-10-27
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 25

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?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 27

Accepted Solution

d-glitch earned 1000 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 1000 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

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

722 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