Question: answer them 17) Consider the sensitivity report below: 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase

answer them

17) Consider the sensitivity report below: 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$3 x1 50 0 13 0.333333333 2.333333333 10 SD$3 X2 25 0 16 3.5 0.4 11 SE$3 x3 0 -1.666666667 17 1.666666667 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Wire Used 100 0 500 1E+30 400 17 $F$11 Nuts Used 700 0 700 1E+30 0 18 $F$12 Bolts Used 700 0.166666667 700 0 60 19 $F$13 Motor Used 75 0 200 1E+30 125 20 $F$14 Blades Used 400 2.333333333 400 37.5 50 21 a) What is the current optimal objective value? (3 points) b) What is the optimal solution if the objective coefficient of X2 is increased to 20? (3 points)

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 Business Writing Questions!

8 9 Part 2: Industrial Designs has used a linear programming model to assign each of its three designers, Lisa, Sarah and David, hours for the LVW label design project. The model is used to minimize...

MGMT 430 Sensitivity Analysis Assignment Week 2 Dropbox 3 Reference the following sensitivity report to answer the questions: Variable Cells Final Reduced Objective Allowable Allowable Cell Name...

MGMT 430 Sensitivity Analysis Assignment - Week 2 - Dropbox 3 Reference the following sensitivity report to answer the questions: Variable Cells Final Reduced Objective Allowable Allowable Cell Name...

The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...

Using the Sensitivity Analysis Report below, what is the optimal objective function value for this problem? Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

Part a. Product 1 currently requires 6 hours of labor, 2 hours on machine 1, 5 hours on machine 2, and 20 feet of sheet metal. Company engineers believe the amount of labor required to make Product 1...

ariable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 5 0 3 4 2 Type B y 3 0 4 6 2 Type C z 0 -4.5 3 1E+30 8 Constraints Final Shadow Co

Dunder Miflin Technologies (DMT) produces trendy tablets. Two of its models are the market leaders: Supercool and Ubercool. Supercool has a profit margin of $200 and Ubercool brings in a profit of...

Solve the following 4 questions with the table below: 1. A factory manufacturing two products(Product A and Product B) using two machines(Machine 1 and Machine 2) follows an optimal production plan...

Question 2. (20 points) A beverage cans manufacturer makes 3 types of soft drink cansneededforthebeverageproducerstofillsoftdrinksofthreedifferentvolumes.Themaximumavailability of the machines' time...

Firm A has the following technology: f(x1; x2)=(xx2). The price of input 1 is w = 8 and the price of input 2 is w2=2. The firm A wants to produce y units of output. Find analytically the conditional...

This project is aimed to perform a series of calculations in the design of an A/C system for a large space serving as an exhibition center for 1500 people, bringing together many subjects in HVAC...

When expenditures exceed revenue there is a budget ________.Responses surplus deficit tax committee tax deficit surplus

What is the harm from port scanning or what harm comes of someone's knowing machines and services?