Question: Problem 2: (Sensitivity Analysis Report) The Excel Solver Sensitivity Report given below is for a maximizing LP Problem with two decision variables and two constraints.

Problem 2: (Sensitivity Analysis Report) The

Problem 2: (Sensitivity Analysis Report) The Excel Solver Sensitivity Report given below is for a maximizing LP Problem with two decision variables and two constraints. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Coefficient Increase Decrease $E$11 X 1 $F$11 Y 60 0 6 3.5 Cost 30 0 5 7 1.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$7 Const 1 Total 120 0.75 120 120 40 $G$8 Const 2 Total 240 1.75 240 120 120 Use the given report to answer the following questions: (a) How many units of X and Y should be produced based on the sensitivity report results? What is the associated optimal value (Z)? (b) What is the optimality range for the first coefficient (Cx) of X? (c) What will be the new optimal value (Z) if the coefficient value of X increased by 2 units? 1E311: Operations Research I- Spring 2021 (d) What is the feasibility range for the first constraint? (e) What is the dual price for each constraint? (1) How much would the profit increase if the right-hand side of constraint l were increased by 40 units? (g) How much would the profit decrease If the right-hand side of constraint 2 were decreased to 80 units

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!

Question 1 A furniture company makes sofa, tables, and chairs. Each piece of furniture requires a fixed amount of wood and metal. In addition, the production of each piece of furniture requires a...

Problem # 1 Lorie Nutritional Diet Planning ( This problem includes 1 4 questions Questions 1 to 1 4 ) Lorie, a diet nutritionist, is working to create a diet plan for a healthy human consumption....

SAINT MARY'S UNIVERSITY SOBEY MGSC 1205 - Winter 2023 SCHOOL OF BUSINESS Assignment #5 Total Points: 30 points Total Value: 5% of the course final grade Due Date: 1 pm Friday, March 17, 2023 Graves...

A = 80 B= 320 Profit = 88 A salad dressing supplier to Ottawa area restaurants has been using Linear Programming (LP) for years to determine how much dressing they should produce for every season. In...

A company manufactures three products X1, X2, and X3 requiring two resources, labor and material. The following LP problem was formulated to determine the production level of each product to maximize...

Problem 1: Ken and Larry, Inc., supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the...

You want to minimize carbohydrate intake. During lunch at your cafeteria, you choose between two dishes, slice of Pizza or a Chinese dish. The table below lists the amount of protein, carbohydrates,...

Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively: Maximize profit = $5X + $5Y Subject to the constraints 2x + 3Y =0...

The tables that follow make up the sensitivity report for Eli Willy (a pharmaceutical distributor). Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

Economics how you go the answer B) Next identify the unit of measure you will use to count your output (you cannot use time or money since you do not produce either). Unit of measure Good 1: Unit of...

Coal and other fossil fuels usually contain sulfur compounds that produce sulfur dioxide, SO2, when burned. One possible way to remove the sulfur dioxide is to pass the combustion gases into a tower...

2 What is represented by the difference between the amount of assets and the amount of liabilities? Owners' equity Net change in cash Net income Gross profit

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...