Question: Solve the following LP problem using Excel: Maximize profit=3X+2Y subject to the constraints 6X+12Y60 7X+Y20 4X-Y1 X,Y0 You need step by step using Excel using

Solve the following LP problem using Excel: Maximize profit=3X+2Y subject to the constraints 6X+12Y≤60 7X+Y≤20 4X-Y≥1 X,Y≥0

You need step by step using Excel using the format below showing the formulas

XY
Variables
objective coefficient
restrictions:
Constraint 1
Constraint 2
Constraint 3
LHSSignright side

Step by Step Solution

★★★★★

3.50 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ANSWER Explanation Solution I We hav... View full answer

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!

Q:

Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4X + 5y Subject to the constraints 5X + 2y 3 x,y >0

Q:

Solve the following LP problem using level curves. MAX: 4X1 + 5X2 Subject to: 2X1 + 3X2 120 4X1 + 3X2 140 X1 + X2 80 X1, X2 0

Q:

Solve the following LP problem by using the graphical procedure and by using Excel: Minimize cost = 4X + 7 Y subject to the constraints 2X + 3y > 60 4X + 2y > 80 X 0

Q:

Solve the following LP problem graphically: lop4 Maximize profit = X + 10Y Subject to: 4X + 3Y 36 2X + 4Y 40 Y 3 X, Y 0

Q:

Solve the following LP problem using Excel Solver and report the objective function value at the optimal solution. Note that this is a minimization problem that has 4 decision variables (x1, x2, x3,...

Q:

Solve the following LP problem using the corner point graphical method. At the optimal solution, calculate the slack for eachconstraint: Maximize profit = 4X + 4Y subject to

Q:

Solve the following LP problem using Two - Phase Method: Maximize z = x 1 + 2 x 2 + x 3 Subject to x 1 + x 2 + x 3 = 7 2 x 1 - 5 x 2 + x 3 1 0 x 1 , x 2 , x 3 0

Q:

0 Hcrcvok_ussignment 1.pdf Los robat Kosda DCIC46:1 Tile Fl Viva Siye Wi- Home Tools Harrack_Assign. Sign In H e 92 : od 10 Search Draw Ractangla P. Export PDF V Reference to Lectures: o The text...

Q:

=7-22 Solve the following LP problem using the corner point graphical method. At the optimal solution, calculate the slack for each constraint: Maximize profit subject to = + + + 4 4 3 5 150 2...

Q:

Solve the following LP Problem using Algebraic Method [Page 169] [ 1.5 Marks.] max z = 5 x 1 + 2 x 2 s.t. x 1 + x 2 6 s.t. x 1 - x 2 0 x 1, x 2 >= 0 Find the optimal solution to the following LP:...

Q:

Write down your preliminary thoughts on possible solutions to address the clients requirements. Make sure you conduct research to identify these solutions and describe the research you conducted....

Q:

Water at atmospheric pressure and 180 F enters a mixing chamber at a flow rate of 80 gpm. Cold water enters the mixing chamber at 40 F at a flow rate of 120 gpm. Calculate the temperature of the...

Q:

What is the direction under the Client Focused Reforms regarding an unsuitable unsolicited order?

Q:

The 1.62-oz golf ball is struck by the fi ve-iron and acquires the velocity shown in a time period of 0.001 sec. Determine the magnitude R of the average force exerted by the club on the ball. What...

Q:

The sliding plate viscometer shown below is used to measure the viscosity of a fluid. The top plate is moving to the right with a constant velocity of V = 22 m/s in response to a force of F = 1 N....

Q:

A plant consumes 60 kW at a power factor of 0.5 lagging from a 220-V rms 60-Hz line. Determine the value of the capacitor which when placed in parallel with the load will change the load power factor...

Q:

An educator wants to compare the effectiveness of computer software for teaching biology with that of a textbook presentation. She gives a biology pretest to each student in a group of high school...

Q:

Mike Samson is a college football coach making a base salary of $652,800 a year ($54,400 per month). Employers are required to withhold a 6.2% Social Security tax up to a maximum base amount and a...

Q:

Consider the function:f(x)=2x^3+x^2x. Evaluate f(1)f(1), f(2)f(2), and f(7)f(7), if they exist. If they do not exist, select "Does Not Exist".

Q:

Please help doing this in excel, thank you! 1. Solve the following LP problem Max Z= 8X1 + 10X2 S.T. XI + 4X2 0 2. Solve the following LP problem Max Z= 3X1 + 5X2...

Q:

Consider the following LP problem a) Solve the following LP problem by graphical methods (label the axes). Be as accurate as possible. Choose the right scale for your axes. b) Now solve the problem...

Q:

a) What algorithm would you use to solve the following LP problem? Explain your reasoning. b) What algorithm would you use to solve the following LP problem? Explain your reasoning. c) Solve both...

Q:

16.3 GRAPHICAL METHOD As already stated, if the number of variables in any linear programming problem is two, one can use the graphical methods to solve it. In this section, the same is demonstrated...

Q:

16.3 GRAPHICAL METHOD As already stated, if the number of variables in any linear programming problem is two, one can use the graphical methods to solve it. In this section, the same is demonstrated...

Q:

Solve the following LP problem by graphical methods (label the axes). Be as accurate as possible. Choose the right scale for your axes. a) Read the (approximate) values of the variables x1 and x2 off...