Solver in Excel in Hindi

You can use Solver to solve multiple variable problems. Let's look at this intersting situation: You have a Rs.200 voucher to spend on soap. A small (100g) soap costs Rs. 17, a large (250g) one is Rs. 32. Also, there's a special offer on the small soap: if you buy 3 you get one free. You want to buy as many soaps as possible and you want to spend every paisa as the shop doesn't give change for a voucher. How many of each sort should you buy?
First we enter the headings 'Number', 'Weight' and 'Cost' in cells B2, C2 and D2.
Next we enter 'Large', 'Small' 'Offer', 'Total small' and 'Budget' in cells A3, A4, A5, A6 and A8 respectively.
In cell B6 we enter the formula '=B4+4*B5'
Under the weight column we now use a simple formula to calculate the weights of the soaps. Example: '=B3*1' for the large soap and '=B4*1' for the small soap.
In cells B6, C6 and D6 we sum the numbers, weights and costs.
In cell A8 we enter 'Budget' and in cells B8 we enter '200' which is the value of our voucher.
Then we click on 'Data', select solver
In the new window that pops up we select cell C6, select max
In the 'By Changinging Cells' textbox we enter or select cells B3 to B5
In the constraints we have added 3 variables:
1. The values of cells B# to B5 must be an integer
2. The values of B3 to B5 must be greater than 0 so that we get only complete soaps
3. Our budget (200) must be equal to our total cost of purchase because we wish to spend all the money as the shop will not give us any balnce back as per the terms and conditions on the gift voucher.
On clicking on solve we find that we can get 10 small soaps and two large soaps.
We have then tried out another combination where we tell solver that the cost can be equal to or less than our budget. We find an amazing solution: we spend Rs.198 and get 3 large soaps and 8 small soaps, a total of 1550 grams! We now don't mind foregoing the 2 rupees.

Solver in Excel in Hindi