Help With Solver Please

[helen wheels]

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

 

[OssieMac]

You need to know the proportion of members to non members or it is not
solvable.

See the following examples. Shows that the price changes significantly with
the proportion of members to non members.

Category Number Ticket price Break even amount
non members 200 $20.00 $4,000.00


non members 100 $22.85 $2,285.00
members 100 $17.15 $1,715.00
$4,000.00

non members 50 $24.65 $1,232.50
members 150 $18.45 $2,767.50
$4,000.00