Break Even Analysis

G

Guest

I need to do break even analysis. Airline Ticket A is $100. Airline Ticket
B is $125. Airline Ticket A gets me to my destination in 4hrs. Airline
Ticket B gets me there faster. How much faster would be necessary to justify
the extra cost?

What is the procedure to accomplish this in Excel?

Many thanks for helping me!!
 
M

Mike Middleton

Tess -

The data you have specified ($100, $125, 4 hours) does not include
information about how you value your time, so I regard the problem statement
as being incomplete. If you specify the tradeoff (money vs. travel time)
explicitly, then you can use Excel to do the arithmetic.

- Mike
www.mikemiddleton.com
 

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

Count number of indirect connections between airports 0
Wrapping Text when using MailMessage 5
Calculation to Obtain Compliance % Using Count of Partial Field V 1
Foreign Key 1
Break Even Analysis 2
Strange Combo box "bug"? 3
Attempting an inventory management database 7
If Operating Systems Ran The Airlines... 1

Top