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?

Thank you.

LJK