Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. Consider the following LP problem, in which X and Y denote the number of units of products X a to produce, respectively: Maximize profit

image text in transcribed
image text in transcribed
6. Consider the following LP problem, in which X and Y denote the number of units of products X a to produce, respectively: Maximize profit = $5X+$5Y subject to the constraints 2X+3Ys60 (resource 1) 4X+2Y$80 (resource 2) Xs 18 (resource 3) X,Y20 (nonnegativity) The Excel Sensitivity Report for this problem is shown below. Calculate and explain what happens to optimal solution for each of the following situations. Each question is independent of the other questions. Variable Cells Fina Reduce Allowab Allowab d Objective le le Valu Coefficie Decreas Cell Name e Cost nt Increase e $B$ Solution value 15.0 4 X 0 0.00 5.00 5.00 1.67 $C$ Solution value 10.0 4 Y 0 0.00 5.00 2.50 2.50 Constraints Fina Shado Constrai Allowab Allowab W nt le le Valu Decreas Cell Name e Price R.H. Side Increase e $D$ 60.0 7 Resource 1 0 1.25 60.00 60.00 12.00 $D$ Resource 2 80.0 0.63 80.00 8.00 40.00

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

Management Accounting

Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Phillip Beaulieu

6th Canadian edition

013257084X, 1846589207, 978-0132570848

More Books

Students also viewed these Accounting questions

Question

Under what conditions is the return on assets equal to the ROE?

Answered: 1 week ago

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago