Question: Will the current optimal solution stay optimal if we add a constraint that says production quantity of SUV tires should be at most 85? (Yes

Will the current optimal solution stay optimal if

Will the current optimal solution stay optimal if we add a constraint that says production quantity of SUV tires should be at most 85? (Yes or No)
(Calculate the effect on the total profit of increasing the available time for shipping to 160.
Calculate the effect on the total profit of decreasing the available time for production to 400.

OPRE 3333 - Homework 5 Question 3. (20 points) Robin Tires, Inc. makes two types of tires, for SUVs and Hatch- backs. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table: Production Hours Type Production Packaging Shipping Profit/Tire SUV Tires $22 Hatchback Tires 1.5 1 0.5 $12 Production 1 .5 Assume that the company is interested in maximizing the total profit contribution. The sensitivity report provided below was generated using the Excel Solver to determine the optimal solution to this problem. Using the sensitivity report, answer the following: Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 11/12/2018 1:58:45 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $E$3 1000 222 $F$3 100 0 12 2.666666667 1 Constraints Final Shadow Cell Name Value Price $G$10 150 16 $G$8 350 0 $G$9 250 4 Constraint Allowable Allowable R.H. Side Increase Decrease 150 16.66666667 25 500 1E+30 150 250 5025

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!

will the current optimal solution stay optimal if we add a constraint that says production quantity of large can per day should be at least 5

Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$3 300 4.5 300 400 71.4285714 $D$4 525 0 400 125 1E+30 $D$5 300 0 700 1E+30 400 What is the...

a) What is the optimal value of the variable in cell A1? 0 4 13 Infinity b) What is the optimal objective value? 0 75 1350 None of the above c) Will the current optimal solution stay optimal if we...

NEED ASAP!!! PLEASE!!!! Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $A$1 0 4 13 1E+30 1 $B$ 0 1.5 24 1E+30 1 $C$ 7 5 0 18 1.2 Allowable Decrease 4 1.5...

Question 3. (20 points) Robin Tires, Inc. makes two types of tires, for SUVs and Hatch- backs. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping....

Question 2. (20 points) A beverage cars manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the...

Question 2. (20 points) A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the...

The economy is in a recession, the recessionary gap is large, and there is a budget deficit. a. Do we know whether the budget deficit is structural or cyclical? Explain your answer. b. Do we know...

The program is written in c. How to implement the following code without using printf basically without stdio library? You are NOT allowed to use any functions available in . This...

3 8 . When a genc is no longer essential and accumulates mutations that render it non - finctional, it becomes a

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...