Question: SOLVE the Following LP, USING EXCEL SOLVER Min: 5x^1+4x^2 Constraint 1: 4x1+x2 = 22 Constraint 3: 3x1+2x2 >= 18 X1 , X2 >= 0 1.

SOLVE the Following LP, USING EXCEL SOLVER

Min: 5x^1+4x^2

Constraint 1: 4x1+x2 <= 28 * X1 and X2 are variables**************

Constraint 2: 2x1+3x2 >= 22

Constraint 3: 3x1+2x2 >= 18

X1 , X2 >= 0

1. what is optimal solution... vlaues of x1 and x2

2. what is the optimal objective function value

3. at optimality, which constraints are binding?

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!

Q:

OR 1 -please only provide me with the answers on exel before and after operations research 4. Solve the following LPs using Excel Solver. Report the optimal solution for each LP. Provide Excel output...

Q:

Think broadly about this decision process. Write-up a discussion of questions like the following. What hasn't been included above? Do you think these missing things should be included? What...

Q:

List all assumptions you got directly from the question description in order to complete (a) - (c). List and justify all additional assumptions you needed to make. I have attached the answers of (a)...

Q:

Please solve the following question using excel commands like solver, Analytic Solver, or sensitivity analysis. 5. Reconsider the model given in Problem 5.2. While doing what-if analysis, you learn...

Q:

Consider the following LP problem. Maximize z = 3 x 1 + 2 x 2 , subject to Constraint 1 : 2 x 1 + 3 x 2 4 0 , Constraint 2 : 3 x 1 + x 2 3 0 , Constraint 3 : x 1 , x 2 0 , where x 1 and x 2 represent...

Q:

The BBQ is a restaurant located in New York. To help plan an advertising campaign for the coming season, BBQ s management team hired the advertising firm AC . The management team requested AC s...

Q:

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

Q:

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

Q:

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

Q:

ADM 2302 -Assignment #1 Problem 1 (15 points) The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund...

Q:

Draw the three distinct geometric isomers of 2,4-hexadiene.

Q:

You are required to calculate the correlation between the daily hours spent playing video computer games (X) and academic average (Y). The correlation was -0.834. The means and standard deviations...

Q:

General accounting NextGen Consulting Services estimates its direct labor costs to be $2,500,000 for the year. The estimated direct labor hours are 40,000. Overhead is allocated based on direct labor...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...