Problem 4: Sensitivity Analysis (Total 25 points) Consider the following linear program. Solve using the graphical...
Can i have the complete solution for this? if needed using excel solver and the explanaition. thank you!!! 1. A company manufactures two products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials, M1 and M2, used in the manufacture of the two products have daily availabilities of 8 and 18 units, respectively. One unit of A uses 2 units of M1 and Aunits of M2, and 1 unit of B uses@ units of M1...
Consider the following linear programming problem Manimize $45X1 + $10X2 Subject To 15X1 + 5X2 2 1000 Constraint A 20X1 + 4X2 > 1200 Constraint B X1, X2 20 Constraint C if A and B are the two binding constraints. a) What is the range of optimality of the objective function? 3 C1/C2 s 5 b) Suppose that the unit revenues for X1 and X2 are changed to $100 and $15, respectively. Will the current optimum remain the same? NO...
please solve it manually 1. A company produces two products, A and B. The unit revenues are $2 and $3, respective- ly. Two raw materials, M1 and M2, used in the manufacture of the two products have re- spective daily availabilities of 8 and 18 units. One unit of A uses 2 units of M1 and 2 units of M2, and 1 unit of B uses 3 units of M1 and 6 units of M2. (a) Determine the dual prices...
Q4. (Sensitivity Analysis: Adding a new constraint) (3 marks) Consider the following LP max z= 6x1+x2 s.t.xi + x2 S5 2x1 + x2 s6 with the following final optimal Simplex tableau basis x1 r2 S2 rhs 0 0 18 0.5 0.5 0.5 0.5 x1 where sı and s2 are the slack variables in the first and second constraints, respectively (a) Please find the optimal solution if we add the new constraint 3x1 + x2 S 10 into the LP (b)...
Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max Z= subject to: 31 +2x2 < 24 2x1 + 4x2 = 12 -2x1 + 2 x2 56 X1, X2 > 0 Variable Cells Cell Name $B$13 Solution x1 $C$13 Solution x2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6 0 10 1E+30 0 -12 8 12 1E+30 6 Constraints Cell $D$6 $D$7 $D$8 Name C1 Totals C2 Totals C3 Totals Final...
SOLVE STEP BY STEP! 4. Consider the following LP: Minimize z = x; +3x2 - X3 Subject to x + x2 + x2 > 3 -x + 2xz > 2 -x + 3x2 + x3 34 X1 X2,43 20 (a) Using the two-phase method, find the optimal solution to the primal problem above. (b) Write directly the dual of the primal problem, without using the method of transformation. (c) Determine the optimal values of the dual variables from the optimal...
Exercise 2 Linear Programming 1. The Scrod Manufacturing Co. produces two key items – special-purpose Widgets (W) and more generally useful Frami (F). Management wishes to determine that mix of W & F which will maximize total Profits (P). Data W F Unit profit contributions $ 30 $ 20 Demand estimates (unit/week) 250 500 Average processing rates – each product requires processing on both machines (units/hour) Machine #1 2 4 Machine #2 ...
Problem 1: Financial Statement Ratio Analysis (40 points total) Use the following financial statements for Dell, Inc. to answer the questions which follow: BALANCE SHEET (SMil) 2017 10,298 2018 7,972 % 28.9 2019 9,092 % 34.3 40.2 Cash & Short Term Investments Accounts Receivable Inventory Other Current Assets Total Current Assets Net Fixed Assets Intangibles Other Long Term Assets Total Assets 6,152 24.0 660 2.6 2,829 11.3 19.939 76.6 2,409 8.7 0 0 3,287 14.7 25,635 100.0 7,693 27.9 1,180...