Question: Solve the following linear programming problem by Excel's Solver. Use the output to answer the questions MAX 25X1+30X2+15X3 ST 4X1+5X2+8X3

Solve the following linear programming problem by Excel's Solver. 

Use the output to answer the questions 
MAX 25X1+30X2+15X3 ST 
4X1+5X2+8X3<=1200 
9X1+15X2+3X3<=1500 

1. What are the Binding Constraints and the Optimum amount of Objective Function? 

2. What are the slack values for Constraint and Constraint 2? 3

3. Looking at the Shadow prices, how much would the objective function change by if Constraint 1 increases by 100 units? 

4. What 0/0 of available Constraint 2 can be reduced without it affecting the current shadow price ? 

5. Why the amount of reduced costs of and X 3 are zero?

Step by Step Solution

★★★★★

3.59 Rating (163 Votes )

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 Mathematics Questions!

Q:

The following linear programming problem has been written to plan the production of two products. The company wants to maximize its profits. X1 = number of product 1 produced in each batch X2 =...

Q:

Solve the following linear programming problem graphically: Maximize profit = 4X + 6Y Subject to: X + 2Y 8 5X + 4Y 20 X,Y 0

Q:

Gires results after developing the excel LP nad Saher: QUESTIONS: Sensitivity Analysis (25 Points) The following linear programming problem has been solved by Excel's Solver. Use the output to answer...

Q:

Note: Unless noted we assume the decision variables do not have to be integer. Q1 ~ Q9 Jack, a ring maker, is interested in determining which items he should make for the upcoming month. His three...

Q:

Jack, a ring maker, is interested in determining which items he should make for the upcoming month. His three most popular selections are a start sapphire cocktail ring, a royal ruby friendship band,...

Q:

Jack, a ring maker, is interested in determining which items he should make for the upcoming month. His three most popular selections are a start sapphire cocktail ring, a royal ruby friendship band,...

Q:

The following linear programming problem has been solved by LINDO. Use the output to answer the questions. (Scroll down to see all). LINEAR PROGRAMMING PROBLEM MAX 41X1+52X2+21X3 S.T. C.1) 5X1 + 5X2...

Q:

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Q:

Question 4: Sensitivity Analysis (13 Points) Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all >...

Q:

In 2 0 2 4 , internal auditors discovered that PKE Displays, Incorporated, had debited an expense account for the $ 2 5 2 , 0 0 0 cost of a machine purchased on January 1 , 2 0 2 1 . The machine's...

Q:

Consider the following classic portfolio choice problem. Two assets are available to an investor at time t. One is riskless, with simple return Rf from time t to t+1 , and the other is risky. The...

Q:

What type of alcohol is (E)-2-methylhex-4-en-2-ol? O primary O secondary tertiary quaternary

Q:

Case 21-4 Grocery Inc. Grocery Inc. (Grocery or the Company), an SEC registrant, is a wholesale grocery distributor and retailer in the United States. One of the Companys core businesses is...

Q:

Prepare the statement of cash flows for the current month. Note: Cash outflows should be indicated with a minus sign. Required information [The following information applies to the questions...

Q:

find all matrices A (a) A = 13 (b) A + A = 213

Q:

Question 2 Lawless Trust is a discretionary trust, with an Australian incorporated company as trustee. The trust derived the following income in this income year. $600,000 profits from running a...

Q:

Which property determines whether a control is available to the user during run time? a. Available b. Enabled c. Unavailable d. Disabled

Q:

The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. Probability distributions for the purchase cost, the labor cost, and the...

Q:

A large corporation collected data on the reasons both middle managers and senior managers leave the company. Some managers eventually retire, but others leave the company prior to retirement for...

Q:

Better Fitness, Inc. (BFI) manufactures exercise equipment at its plant in Freeport, Long Island. It recently designed two universal weight machines for the home exercise market. Both machines use...

Q:

=+2. A random sample of ten homes in a particular area, each heated with natural gas, is selected, and the amount of gas (therms) used during January is determined for each home. The resulting...

Q:

=+b. Repeat the probability calculation in part (a) for samples of size n550, n5100, and n51000. (Use the normal approximation to the binomial.)

Q:

=+a. For random samples of size n510, calculate the area under the sampling distribution curve for x between the values 2 1 and 1 1. That is, find the probability that the sample mean lies within...