Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 5 Below there is the sensitivity table of the solution of the model in 1* question. (In the exam there will be a separate

image text in transcribed
QUESTION 5 Below there is the sensitivity table of the solution of the model in 1* question. (In the exam there will be a separate example in such a question but here I give this as a hint to the constraints in Q1] Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$11 Available Region A oil 100 0 300 1E+30 200 $D$11 Available Region B oil 400 400 50 0 $E$11 Available Region C oil 500 500 1800 0 $C$7 Maximum Region A oil in Type A 25 0 50 0 $C$8 Maximum Region A oil in Type B 25 0 0 50 0 $C$9 Maximum Region A oil in Type C 25 0 0 50 0 $C$10 Maximum Region A oil in Type D 25 0 0 180 0 $E$7 Minimum Region C oil in Type A 75 0 50 75 $E$8 Minimum Region C oil in Type B 125 0 50 1E+30 $E$9 Minimum Region C oil in Type C 75 0 50 75 $E$10 Minimum Region C oil in Type D 225 0 150 1E+30 $F$7 Demand Type A 250 0.3 250 0 83.33333333 $F$8 Demand Type B 250 250 0 83.33333333 $F$9 Demand Type C 250 0 250 0 83.33333333 -5.68434E- $F$10 Demand Type D 250 0 250 14 1E+30 They consider several options to increase profitability. Please write your suggested course of action and the expected change in profit for the following problems. a.) What happens to cost if Demand of Type D increase to 260? b.) What happens to cost if Demand of Type D increase to 260 while demand of Type A decrease to 240? c.) There is a new type that they can start to produce. It will not have any minimum or maximum usage of region oils to add as constraint, but its introduction will decrease the demand of type A to 200. The cost of adoption of new type is considered to be around $50. Should this new type be produced

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry, Enhanced

Authors: Cynthia Y Young

4th Edition

1119320860, 9781119320869

More Books

Students also viewed these Mathematics questions

Question

15 3 - (2 - 7)(2) Perform the indicated operations by hand.

Answered: 1 week ago

Question

3. Identify cultural universals in nonverbal communication.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago