Please help doing this in excel, thank you!

1. Solve the following LP problem Max Z= 8X1 + 10X2 S.T. XI + 4X2 < 12 3X1 + 2X2 12 2X1+ X258 XI, X2>0

2. Solve the following LP problem Max Z= 3X1 + 5X2 S.T. 4X1 + 3X2 24 2X1+ 3X2 <18 xi, x2>0

3. Given the following LP problem: Max z= 5X1 + 7X2 S.T. XI 5 6 2X1 + 3X2 519 XI + X2 8 XI, X220

a) Solve the problem.

b) Identify the reduced costs and interpret each.

c) Calculate the range of optimality for each objective function coefficient.

d) Identify the slacks for the resources and calculate the shadow price for each resource