Hi I'm doing the Edexcel A-level and my task is to get the high profit I can.
I have 2 variables; the price of a ticket, and the amount of people willing to buy at that ticket price.
The second variable changes proportionally to the ticket price.
So what I want to know is if there is way to use GoalSeek or some other function which which tries all possible prices and gets the highest profit.
If I haven't made anything clear please let me know, and I'll try to re-explain my situation.
Thanks in advanced,
Using GoalSeek to find highest value possible? Edxcel LyonAir Watch
- Thread Starter
- 10-12-2010 01:30
- 10-12-2010 19:34
What is the formula which relates the ticket price and number of people?
I haven't done ICT/Computing A-Level, but is that all it needs you to do? Find the optimum price?
- 06-01-2011 21:02
well i m really confused with that stuff !!!!
i dont know anything about it ...wat to do and where to start !!
please guide meee !!!!
- 11-01-2011 22:57
Well if the computer has Solver, then it will be possible too find the maximum revenue