Help With Solver Please

  • Thread starter Thread starter helen wheels
  • Start date Start date
H

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
 
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
 
Back
Top