Implement the lp model in a spreadsheet

Assignment Help Business Management

Reference no: EM1366402

Implement the following LP model in a spreadsheet.

Implement the following LP model in a spreadsheet. Use Solver to solver the problem and create a Sensitivity Report. Use this information to answer the following questions.

MAX: 2Xi + 4X2
Subject to: -X! + 2X2 < 8
Xi + 2X2 < 12
Xi+ X2> 2 Xi,X2> 0

a. Which of the constraints are binding at the optimal solution?

b. Is the optimal solution to this problem unique, or is there an alternate optimal solution?

c. What is the optimal solution to this problem if the value of the objective function coefficient for variable Xi is zero?

d. How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?

e. Given the objective in this problem, if management could increase the RHS value for any of the constraints for identical costs, which would you choose to increase and why?

Reference no: EM1366402

Questions Cloud

Women in the workforce and the glass ceiling : Do you believe that an affirmative action plan based on gender (i.e., favoring women in hiring) is an ethical way to deal with the issue of the glass ceiling

Implementation of new technology : What are some factors management should examine prior to approving a change in its company's technology?

Can external validity and internal validity affect other : Explain why. How can external validity and internal validity affect one another?

Work specialization and brainwashing : Work specialization can be best described as "the degree to which activities in the organization are subdivided into separate jobs"

Implement the lp model in a spreadsheet : How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?

Principles and prevention of bureaucracy : How can the principles of bureaucracy help managers to design the organizational hierarchy? What can managers do to prevent bureaucratic problems from arising?

Bottlenecks in tube manufacturing : Bottleneck in a tube manufacturing process. Explain Theory of Constraints and how bottlenecks can be managed.

Formal research vs business proposal : There is no relationship between customer satisfaction and loyalty and a significant relationship exists between the age of the workforce and increased levels of job satisfaction.

Rate the characters on their level of moral development : List in order the characters in this story that you like, from most to least. What values governed your choices and rate the characters on their level of moral development.

User Account

All Pages