operations research

4. Solve the following LPs using Excel Solver. Report the optimal solution for each LP. Provide Excel output as well. max z = B + 1.9D + 1.5E + 1.0892 s.t. A + C + D + So = 100,000 0.5A + 1.2C + 1.08S6 = B + S A + 0.5B + 1.085 = E + S2 A $ 75,000 B = 75,000 CS 75,000 D = 75,000 E s 75,000 A, B, C, D, E, SO, S1, S2 2 0 V = 50 min z = 1,000x, + 1,000x2 + 1,000x3 + 1,000x4 + 1,000x5 + 2,000y+ 2,000y2 + 2,000y3 + 2,000y4 + 2,000y5 s.t. 160y, - 50x12 6,000 160y2 - 50x27,000 0.95y + xy = y2 160y3 - 50xz 8,000 0.95y2 + x2 = y3 160y4 - 50x49,500 0.95y3 + x3 = y4 160ys - 50x5 2 11,000 0.95y4 + X4 = ys x, y, 20 (t = 1, 2, 3, 4, 5)