question 5 on excel

Exercise N:4 (Solving LP with Simplex) (5 pts.) Solve the following LP model by the simplex method (show ALL the steps in Simplex tableau): s.tMaxz=2x+4y2x+3y48x+3y42x+y21x,y0 Exercise N:5 (Solving LP using MS. Excel Solver) (4.5 pts.) Use the MS Excel Solver to find the optimal solution (if exists) to the following LP: Minz=7x1+6x2+4x34x1+7x2++9x374x1+2x2+5x3833x1+x2+7x366allxs0 Microsoft Excel 16.0 Answer Report Worksheet: [GiapettoSolver.xlsx]Sheet1 Report Created: 10/2/2022 8:54:35 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1\%, Assume NonNegative Qhiective Cell (Max) Constraints