Use the information to setup and solve the problems in Excel with Solver.

All three problems can be solved within one file by using different sheets (tabs).

Please show step by step how to do this in excel.

1. Consider the following LP model:

Max Z = 10X1 + 3X2

Subject to: 6X1 + 7X2 40

3X1 + 1X2 11

X1 , X2 0 and Integer

2. Consider the following LP model:

Minimize Z = 3X1 + 4X2

Subject to: 2X1 + 4X2 8

2X1 + 6X2 12

X1 , X2 0 and Integer

3. Consider the following LP model:

Max Z = 5X1 + 8X2

Subject to: 6X1 + 5X2 30

9X1 + 4X2 36

1X1 + 2X2 10

X1 , X2 0 and Integer