Break Even Point
 

Hello,

Is there a formula to calculate a break even point? Scenario: Rate ranges
are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper has
load that weighs 990 lbs. What is the break even point to move the load
forward into the next cheaper range.

Hope that makes sense.

Any help appreciated.

Break Even Point
 

"Break even" generally implies two opposing trends. Where they meet is the
'break even' point. You have supplied only one 'trend'. Can you expand on
the problem?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Connie" wrote in message
...
Hello,

Is there a formula to calculate a break even point? Scenario: Rate
ranges
are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper has
load that weighs 990 lbs. What is the break even point to move the load
forward into the next cheaper range.

Hope that makes sense.

Any help appreciated.

Break Even Point
 

Unfortunately, the only info I will ever have for this is the actual weight,
the ranges and the amount to charge for each range. Any suggestions?

"Bernard Liengme" wrote:

"Break even" generally implies two opposing trends. Where they meet is the
'break even' point. You have supplied only one 'trend'. Can you expand on
the problem?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Connie" wrote in message
...
Hello,

Is there a formula to calculate a break even point? Scenario: Rate
ranges
are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper has
load that weighs 990 lbs. What is the break even point to move the load
forward into the next cheaper range.

Hope that makes sense.

Any help appreciated.

Break Even Point
 

Then the problem has no solution!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Connie" wrote in message
...
Unfortunately, the only info I will ever have for this is the actual
weight,
the ranges and the amount to charge for each range. Any suggestions?

"Bernard Liengme" wrote:

"Break even" generally implies two opposing trends. Where they meet is
the
'break even' point. You have supplied only one 'trend'. Can you expand on
the problem?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Connie" wrote in message
...
Hello,

Is there a formula to calculate a break even point? Scenario: Rate
ranges
are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper
has
load that weighs 990 lbs. What is the break even point to move the
load
forward into the next cheaper range.

Hope that makes sense.

Any help appreciated.