Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

I've been having a difficult time with figuring out a problem using solver to figure our the following and come up with a graph.

First product pound contains 20% cp, 20% rb and 15% mb

Second product pound contains 30% cp, 25% rb and 10% mb

First product costs $90 for each pound

Second product costs $120 for each pound

I want to buy enough of both products to get at least 8 pounds of cp, 6 pounds of rb, and 5 pounds of mb while paying the least. For this, I'm using an LP model and trying to sketch a region but it's not making much sense as well as the optimal price.

Thank you in advance.

First product pound contains 20% cp, 20% rb and 15% mb

Second product pound contains 30% cp, 25% rb and 10% mb

First product costs $90 for each pound

Second product costs $120 for each pound

I want to buy enough of both products to get at least 8 pounds of cp, 6 pounds of rb, and 5 pounds of mb while paying the least. For this, I'm using an LP model and trying to sketch a region but it's not making much sense as well as the optimal price.

Thank you in advance.

BTW - is this for academic or self-study purposes?

Objective

```
A B C D
Minimize Cost 0
```

```
Pounds of first 0
Pounds of second 0
```

```
Product Name % cp % rb % mb
Actual 0.00 0.00 0.00
Required at least 8.00 6.00 5.00
Pounds of 1st >= 0: 0 0
Pounds of 2nd >= 0: 0 0
```

```
Product Name % cp % rb % mb
First 0.20 0.20 0.15
Second 0.30 0.25 0.10
```

```
Product Name # cp # rb # mb
First 0.00 0.00 0.00
Second 0.00 0.00 0.00
Total 0.00 0.00 0.00
```

Any non-zero numbers are taken from your OP. The 0's in the 3 fields in

The first step in using the Solver is to make sure you have the formulas correct. So, just put in arbitrary values such as 1 and 10 and verify that all the 0's are computed correctly. If you have problems doing that, attach your spreadsheet and indicate which cell is causing the incorrect numbers to appear.

I assume that since you wish to use the Solver, then you are already familiar with Excel formulas.

should be: already familiar with Excel formulas (Sum) and simple equations. I'll be back in about an hour to check up on the spreadsheet. The gist of using the solver is to select the Minimize Cost cell having the 0, and then hit the Solver button.

If you set up the form as above, then you can then hit the Guess button, and you should see something like: $B$9:$B$10 corresponding to the two

Then you have to add the constraints by hitting the Add button (5 times for the 5 constraints). You set the Cell Reference (by pointing to the cell), the equality/inequality operator (by pull-down menu), and the Constraint (by pointing to the cell). For each constraint, hit the Add button except for the last constraint, where you hit the OK button. Then you will see the 5 constraints listed, where you can double-check your work.

Something like this (posted Excel file). I assumed you had to purchase whole pounds.

LP.xls

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Does 28 and 8 pounds for first and second items seem right to you?