Homework answers / question archive / Solve the following LP problem graphically using Excel by enumerating the corner points in one worksheet

Solve the following LP problem graphically using Excel by enumerating the corner points in one worksheet

Business

Share With

Solve the following LP problem graphically using Excel by enumerating the corner points in one worksheet. In a separate worksheet solve the problem using Solver. Upload your completed spreadsheet.

X1 – number of softballs

X2 – number of baseballs

Max: 10X1 + 12X2 

Subject to:

8X1 + 6X2 <= 98

6X1 + 8X2 <= 98

X1 + X2 >= 14

X1,X2 >=0