Determine optimal objective function value of lp problem

Assignment Help Basic Computer Science

Reference no: EM1371945

Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report.

MAX: 4X1 + 2X2
Subject to: 2X1 + 4X2 < or = 20
3X1 + 5X2 < or = 15
X1, X2 > or = 0

Use the Sensitivity Report to answer the following questions, explaining your reasoning:

1.What range of values can the objective function coeffieient for the variable X1 assume without changing the optimal solution?

2.Is the optimal solution to this problem unique, or are there alternate optimal solutions?

3.How much does the objective function coefficient for the variable X2 have to increase before it enters the optimal solution at a strictly positive level?

4.What is the optimal objective function value if the RHS value for the second constraint changes from 15 to 25?

Reference no: EM1371945

Questions Cloud

Write the algorithm which takes as input npda : Write the algorithm (described informally) which takes as input NPDA A and determines whether the language of A is nonempty.

How could core erp components aid improve business operation : How could core ERP components aid improve business operations at college? How could extended ERP components aid improve business operations at the college.

Practice of racial profiling in relation to attack : Discuss how various groups, perhaps including the government, justify the practice of racial profiling in relation to the attack on 9/11/01 and/or the bombing of Pearl Harbor.

Deisgn flowchart-hierarchy chart and pseudocode for program : Deisgn a flowchart, hierarchy chart, and pseudocode for program to solve following problem: A student borrows $3,000 at the interest rate of 2 percent per month on unpaid balance.

Determine optimal objective function value of lp problem : Implement given LP problem in a spreadsheet. Use Solver to solve problem and create Sensitivity Report. Determine the optimal objective function value if RHS value for second constraint changes from 15 to 25?

Professional skills for information technology practitioners : Send a business email and write a summary of the information that you have found out about how the company presently operates the system and what the problems are and also write a personal reflection on your team work

Calculating the optimal output in an oligopoly market : Assume that Saudi Arabia lets other members of OPEC sell all the oil they wish at the existing price which udis set and other members accept.

Identify the operational definitions : Identify the operational definitions in the following statements and describe what, if anything, may be wrong with them: (1) smoking is bad for people's health

Write down program which declares integer variables : Write down complete program which declares the integer variable, reads value from the keyboard into that variable, andwrites to standard output variable's value, twice the value.

User Account

All Pages