Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Maximize profit = $4 X + $5 Y

subject to the constraints

X + 2 Y ? 10 (labor available, in hours)

6 X + 6 Y ? 36 (material available, in pounds)

8 X + 4 Y ? 40 (storage available, in square feet)

X , Y ? (nonnegativity)

The Excel Sensitivity Report for this problem is shown in Screenshot 4-9. Calculate and explain what happens to the optimal solution for each of the following situations. Each question is independent of the other questions.

(a) You acquire 2 additional pounds of material.

(b) You acquire 1.5 additional hours of labor.

(c) You give up 1 hour of labor and get 1.5 pounds of material.

(d) The profit contributions for both products X and Y are changed to $4.75 each.

(e) You decide to introduce a new product that has a profit contribution of $2. Each unit of this product will use 1 hour of labor, 1 pound of material, and 2 square feet of storage space.

Step by Step Solution

3.55 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

Enter the data given into an excel file as shown below Products X Y Decision Variables X Y Number of units 2 4 Objective coefficient 400 500 Constraints Max Labor 100 2 Max material 600 600 Max storag... 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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students also viewed these Economics questions