please on excel

only question 5(ex 5)

Exercise N: 1 (Gauss-Jordan) (5 pts.) Use the Gauss-Jordan method to determine whether each of the following linear systems ( Si) has no solution, a unique solution, or an infinite number of solutions. Indicate the solutions (if any exist). S1:x1+x2+x3=2x23x3=12x1+x2+5x3=0S2:3x1+2x22x3=102x1+x2+x3=4x12x2+3x3=7S3:4x1+x2+5x3=4x1+x2+2x3=12x1x2+x3=2 Exercise N:2 (LP Formulation) (5 pts.) Al-Manhal company faces a distribution problem. The company owns three selling points and a factory. The factory manufactures building material with a capacity of 350 tons per week. The storage capacities of the selling points S1, and S2, and S3 are 90 tons, 50 tons, and 85 tons, respectively. Al-Manhal deals with four clients: C1,C2,C3, and C4. The weekly demands from these clients are respectively, 60 tons, 80 tons, 55 tons, and 40 tons. Each of these four clients can purchase material either directly from the factory or from any of its selling points. The following table summarizes the distribution costs in Saudi Riyals (SR.) per ton. For instance, it is worth 6.5SR to ship one ton of material from the factory to store S1 and 10SR to ship from store S2 to client C3. Formulate the LP problem that will help the company managerial to minimize the total distribution cost. Hint: The decision variables to be used in the formulation are: - FSi : number of tons shipped from the factory to store Si(1i3) - FCj : number of tons shipped from the factory to client Cj(1j4) - SCij: number of tons shipped from store Si to client Cj(1i3 and 1j4) Exercise N:3 (Solving LP graphically) (3.5 pts.) Solve the following LP graphically: s.tx4x2y122x+2y18x,y0 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.t2x+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+4x3s.t4x1+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) Conetrainte