Solver displaying wrong result?

[faodavid]

Hi
Im new to solver but have it working, though Im confuse that it is giving the wrong result. On the below I have asked it to calculate min amount of tickets to be sold, as you can see why isn't it suggesting all the highest price tickets to be sold thus reducing total sales needed?

Ticketing Assumptions
Capacity Constraint					1000
Ticket Sales	Type	Constraint	Sales	Constraint	Potential
%	Price	Gross	Net
Earlybird	20%	200	£8.00	£1,600	£1,333
1st Release	30%	300	£12.00	£3,600	£3,000
2nd Release	30%	300	£14.00	£4,200	£3,500
Door	20%	200	£15.00	£3,000	£2,500
		100%	1000	Total	£12,400	£10,333
GOAL 1	BREAK EVEN ON TICKET SALES ONLY						£5,227
GOAL 2	BREAK EVEN ON EVENT
	AVAIL TO SELL	NET			TO SELL	LEFT	GROSS	NET
Earlybird	200	£1,333			81	119	£644	£537
1st Release	300	£3,000			121	179	£1,450	£1,208
2nd Release	300	£3,500			141	159	£1,973	£1,644
Door	200	£2,500			151	49	£2,265	£1,888
	TOTAL NET	£10,333			493
								£5,277

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 3413;"> <col width="193" style="width: 145pt; mso-width-source: userset; mso-width-alt: 8234;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 3029;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1621;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 3029;"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1962;"> <col width="53" style="width: 40pt; mso-width-source: userset; mso-width-alt: 2261;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2346;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2602;"> <tbody> </tbody>