I want to use Solver to solve the following problem, but I can’t work out how and its driving me crazy.
I have to organise a prize giving dinner so I know I need to work out my expenses and make sure I cover those.
I have to break even with 200 ticket sales, but I can sell a maximum of 300 tickets.
Non members pay full ticket price and member pay 75% of the ticket price.
Can someone explain to me how I can set the ticket price using solver?