# Solver displaying wrong result?

#### faodavid

##### New Member
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>

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Replies
1
Views
950
Replies
1
Views
2K
Replies
23
Views
2K
Replies
1
Views
804
Replies
0
Views
569

1,219,957
Messages
6,151,145
Members
451,011
Latest member
Pigdog89

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back