Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following is the sensitivity report from a profit maximization Linear Programming problem in Excel. A firm produces two products P1 and P2. Each of these

image text in transcribed
Following is the sensitivity report from a profit maximization Linear Programming problem in Excel. A firm produces two products P1 and P2. Each of these two products requires three resources R1, R2 and R3 for its production. Answer the following questions based on the sensitivity report. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $K$7 P1 0 -1.5 2 1.5 1E+30 $K$8 P2 500 0 7 1E+30 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$9 R1 1000 3.5 1000 133.3333333 1000 $G$9 R2 500 0 1500 1E+30 1000 $H$9 R3 1500 0 1700 1E+30 200 1) The optimal profit is . (Enter the numerical value in the blank. Don't include any space or text) 2) The objective coefficient for product P1 should be greater than for it to be profitable enough for non-zero production at optimality

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

Stability Analysis Of Nonlinear Systems

Authors: Vangipuram Lakshmikantham, Srinivasa Leela, Anatoly A Martynyuk

2nd Edition

3319272004, 9783319272009

More Books

Students also viewed these Mathematics questions

Question

3. Provide unexpected, spontaneous, and genuine praise.

Answered: 1 week ago

Question

=+6. What five driving forces make CSR more relevant today?

Answered: 1 week ago