Operation Research, EXCEL

For any problems that require a linear program to be solved, please give i) the formulation of the linear program and ii) the excel solution to the linear program.

1) Chapter 1: #13

2) Chapter 2: #23

3) Chapter 2: #45

4) Chapter 3: #17 (For #17b, also provide responses to the following questions:

17b (i): What if, instead of $2 per pound, the supplier offered 500 pounds of steel alloy at $10 per pound?

17b (ii): What if 1000 pounds of steel alloy were available at $2 per pound?)

5) Chapter 3: #19

6) Chapter 3: CP1

7) Chapter 4: #15

8) Chapter 4: #17