ASSIGNMENT 3 (WEEK 3) Solve all questions of the following Linear Programming model using the graphical method (USING EXCEL) {paste the steps which you will be following using computer} Q1) Maximize...

Computation on paper and draft on excel


ASSIGNMENT 3 (WEEK 3) Solve all questions of the following Linear Programming model using the graphical method (USING EXCEL) {paste the steps which you will be following using computer} Q1) Maximize   G = x + 3y    Objective function subject to   x + y ≤ 50 2x + y ≤ 60 x ≥ 0, y ≥ 0    Constraints Q2) Minimize H = 10x + 2y subject to   20x + 25y ≥ 100 12x − 30y ≤ 0 x ≥ 1 x ≥ 0, y ≥ 0 Q3) Objective Function: P = 225x + 200y Contraints :  y ≥ 25;  x ≥ 40;  x + y ≤ 150 Q4) Maximize Z = 2x + 3y   Subject to –2x – y ≥ –10 x + 3y ≥  6 x ≥ 0 y ≥  0  Q5) Minimize F = 3x + y Subject to x + 2y ≥ 4 x + 3y ≥ 6 x ≥ 0 y ≥ 0 Q6) Find the maximal and minimal value of z = 3x + 4y subject to the following constraints: