Question: please do it on excel Max z Subject to: x2 6 5 z - 5x1 - 4x2 6x + 4x2 + 51 X1 + 2x2

please do it on excel

please do it on excel Max z Subject to: x2 6 5 z

Max z Subject to: x2 6 5 z - 5x1 - 4x2 6x + 4x2 + 51 X1 + 2x2 - X1 + = 0 = 24 6 4X2 +52: 4 52 X2 +53 1 2 2X2 X2 X2 = 24 6 1 = 2 +59. 3 X2 +S4 = +54 2 Extrem NB Var. X1 S1 Basic Variables 53 easib N X2 52 54 e 6 0 0 0 X2 4 2 1 1 S2 0 1 0 0 53 0 0 1 0 54 0 0 0 1 24 6 1 2 X2 52 53 54 X2 S2 53 54 X2 52 53 54 X2 52 53 54 2 R1 R2 R3 R4 RX

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 General Management Questions!

Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max Z= subject to: 31 +2x2 0 Variable Cells Cell Name $B$13 Solution x1 $C$13 Solution x2 Final Reduced Objective...

3 Use the Big M method and the two-phase method to nd the optimal solution to the following LP: max z 5x1 x2 s.t. 2x1 x2 6 s.t. x1 x2 4 s.t. x1 2x2 5 x1, x2 0 4 Use the simplex algorithm to nd the...

i need help and steps on this assignment and also if excel steps could be posted please. 1. Consider the following linear programing program: Max Z Z = 5x1 + 4x2 s. t. 2x1 + 2x2 $ 120 3x1 + 2x2 $ 150...

Simplex Algorithm: A Maximization Example. explain the details (steps) of the simplex algorithm. Recall the model Maximize (max) z = 5x1 + 4x2 Subject to (s.t.) 6x1 + 4x2 24 X1 + 2x2 6 -X1 + X2 1...

SIMPLEX METHOD b) (15 points) GRAPHICAL METHOD (do not forget to indicate the feasible region) Max Z =10x1 +11x2 s.a x1 + 2x2 150 3x1 + 4x2 200 6x1 + x2 175 x1, x2 0 Min Z = 25x1 + 30x2 s.a 4x1 + 7x2...

Question 3 2 pts Lego Products, Inc, manufactures tables (x1) and chairs (x2). The profit per table is $20 while the profit per chair is $16. Suppliers can deliver six large and eight small Legos...

Consider the following problem. Maximize Z 3x1 x2 4x3, subject to 6x1 3x2 5x3 25 3x1 4x2 5x3 20 and x1 0, x2 0, x3 0. The corresponding final set of equations yielding the optimal solution...

Big Pine Computing produces two computers, Latitude and Longitude, and wants to plan production for next month to maximize profits. Producing these computers requires wiring, assembly and inspection...

Consider the following four LP formulations. Using a graphical approach, determine (a) which formulation has more than one optimal solution. (b) which formulation is unbounded. (C) which formulation...

Problem 3. Consider the LP max 2x1 + 3x2 s.t -3x1 + x2 51 X1 + 2x2 5 9 X1 + X2 57 X1, X2 20 It is known that the optimal tableau of this LP is 0 0 BVS1z z = 16 1 x2 = 2 0 x = 50 x3 = 140 0 0 1 1 0 0...

Using 2015 as the base year, what is Econ Land's real GDP in 2015 and 2020? Did the nation experience expansion or recession between 2015 and 2020?

The following are the transactions relating to the formation of Cardinal Mowing Services, Inc., and its first month of operations. Prepare an answer sheet with the columns shown. Record each...

a The mass of a girl is 26.5 kg. In this exercise, always use a multiplier to calculate a percentage increase or decrease. Several years later her mass has increased by 62%. Calculate her new mass....

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...