Re: Solver - To Set Ticket Prices
I'm a little confused why you feel you can't use formulas. If you know the number of member and non-member tickets, then the formula is =expenses/(<lower of 200 or # of member tickets>*.75+200-that number of tickets). This will get you the price of a full ticket. 75% of this number would, of course, be the cost of a member ticket.
For example, if expenses of $5000 are entered in A1, and 150 member tickets are available (with this number in B1), then =A1/(B1*.75+200-B1) gets you $30.77 per non-member ticket. 30.77*.75*150+30.77*50=$5000.