Use of Solver Package

Solver package is another valuable package that already included in Microsoft Excel. You can see this package under the Data tab. If you can't see the solver package activate it following below steps.

1. Click on File (Microsoft Windows mark for Excel 2007).
2. Click Options
3. Select Add Ins
4. Select Excel add-ins from the Manage and press go
5. Select the tick mark on Solver add in
6. Press Enter
7. Now You can see Solver has added in under Data Tab

Below data expressing that the merchant who is selling fresh fruit through eBay.com. Please download the data file using this link or copy below data to your excel sheet.

	Buying Price	Quantity	Selling Price	Selling Quantity	Profit
Mango	3	10	5	10	20
Banana	2	8	3	8	8
Pineapple	5	6	7	6	12
				24	40

Here we are going to find out Selling Prices that give maximum profit to the seller. However, maximum no of items he can sell is limited to 20. To do that, follow below steps.

Select the total profit cell and click on solver in the Data Tab.

Click the Max in To group

Select E2:E3 as changing variables.

Click on 'Add' to add constraints. Add below constrains

• Selling quantity of any item cannot exceed the quantity he brought
• Profit of any item can't be zero or minus.
• Item quantity total cannot exceed 20

Press enter.

You can see the result in the Popup window.

You can make permanent them or discard them