| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add break even point | Charts and Charting in Excel | |||
| Formulae to work out break even point? | Excel Worksheet Functions | |||
| how to find Break Even Point with the help of Excel? | Excel Discussion (Misc queries) | |||
| formula for break-even point for a multiproduct | Excel Discussion (Misc queries) | |||
| Break-even point function? | Excel Worksheet Functions | |||
Hybrid Mode
