Break Even Point

C

Connie

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.
 
B

Bernard Liengme

"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
 
C

Connie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating ranges 2
VLOOKUP Help!!! 3
Trying to change a cell formula 2
Break points will be ignored in Excel 1
How do you setup a Break Even Analysis Worksheet 1
IF formula within VLOOKUP (revisited) 4
formula for break-even point for a multiproduct 1
Show a break even point 6

Top