Question: Solve the following 3 variable problem in Excel. Maximize 10X1 + 7X2 + 5X3; subject to the constraints: X1 + X2 + X3 = 70;

Solve the following 3 variable problem in Excel. Maximize 10X1 + 7X2 + 5X3; subject to the constraints: X1 + X2 + X3 <= 100; 2X2 + X3 >= 70; -X2 + X3 <= 150. All variables are non-negative. Which of the following statements is true?

X2 = 36 in the optimal solution.

The optimal solution value is 850

X1 = 65 in the optimal solution.

X3 is 73 in the optimal solution.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Solve the following 3 variable problem in Excel. Maximize 10X1 + 7X2 + 5X3; subject to the constraints: X1 + X2 + X3 = 70; -X2 + X3 = 70 is positive The problem is infeasible. The slack variable for...

TOPIC: LINEAR PROGRAMMING 1.) Solve the following nonstandard maximum problem: Maximize P = 3x, + X2 subject to the constraints: X1+ X2 58 5x1 + 3x2 2 36 7x1 + 4x2 2 14 x1 20, X2 2 0 The maximum of...

Consider the following linear programming problem: Maximize 40 X1 + 30 X2 + 60X3 Subject to: X1 + X2 + X3 90 12 X1 + 8 X2 + 10 X3 1500 X1 = 20 X3 100 X1, X2, X3 0 How many slack, surplus, and...

Consider the following linear programming problem: Maximize 40 X1 + 30 X2 + 60X3 Subject to: X1 + X2 + X3 90 12 X1 + 8 X2 + 10 X3 1500 X1 = 20 X3 100 X1 , X2 , X3 0 How many slack, surplus, and...

Consider the following linear programming problem: Maximize 40 X1 + 30 X2 + 60X3 Subject to: X1 + X2 + X3 90 12 X1 + 8 X2 + 10 X3 1500 X1 , X2 , X3 0. How many slack, surplus, and artificial...

Maximize 10X1 + 7X2 + 5X3; subject to the constraints: X1 + X2 + X3 = 70; -X2 + X3

Question 3. (40 points): Consider the following LP: max z = 3x1 +7x2 +5x3 x s.t. x1 +x2 +x3 +x4 2x1 +3x2 +x3 = 50, X1, X2, X3, X4, X5 0. +x5 = 100, After using the simplex method to solve it, we...

Consider the following linear programming problem P : Maximize z = 6 x 1 + 4 x 2 Subject to x 1 + x 2 8 (1) 2 x 1 -2 x 2 8 (2) x 1 - x 2 2 (3) ____________________________________ x 1 0 x 2...

In a system with a single server, the probability that the server busy is 90% What is the probability that 2 customers are in the system Answer A vending machine at Muscat Airport dispenses hot...

Draw Design Layout References Mailings Review View Help Table Design H 9. Consider the following LP and its optimal tableau: Maximize Z = 3x1 + x2-x3 subject to 2x1 + x2 + x3 8 4x1 + x2-x3 10 X1, X2,...

The information was extracted from the book of Andy Traders for the year ended 31 August 2020 Balance in the debtors ledger on 1 August 2020 H. Mushimba N$3,800 Transaction 11. Credit sales of goods...

A stock quote indicates a stock price of $60 and a dividend yield of 3%. The latest quarterly dividend received by stock investors must have been ______ per share.

Choose the statement that is INCORRECT regarding a loss that is generated from the disposal or sale of assets for individuals. Multiple choice question. When capital losses exceed capital gains, up...

1.Calculate the payout ratio from the following available information. ET SISO,00, interest expense $16,000, tax rate 30%, dividends paid $10,000 T