Question: Consider the following linear program Max 12A + 9B s.t 5A + 15B

Consider the following linear program Max 12A + 9B s.t 5A + 15B <= 25 10A + 6B <= 26

a) Use Excel solver the find the optimal solution and generate the sensitivity report. What is the optimal solution? Use the Sensitivity report to answer the following questions:

b) Assume that the objective function coefficient for A changes from 12 to 16. Does the optimal solution change? Why?

c) Assume that the objective function coefficient for A remains 12, but the objective function coefficient for B changes from 9 to 12. Does the optimal solution change? Why?

d) Based on the shadow price and the right-hand-side range information in Sensitivity report, what conclusion can you draw about the effect of changes to the right-hand side of the constraint 1.

Step by Step Solution

★★★★★

3.40 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The optimal solution is A 2 and B 1 A B Sum 2 1 33 Constraints 25 26 sensitivity report for this M... View full answer

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

What conclusion can you draw about the effect of the probabilities on EVPI from Exercises 22.19 and 22.20?

What conclusions can you draw about the effect of the prior probabilities on EVSI from Exercises 22.2522.27?

Consider the following linear program: Min 2A + 2B s.t. 1A + 3B 12 3A + 1B 13 1A - 1B = 3 A, B 0 a. Show the feasible region. b. What are the extreme points of the feasible region? c. Find the...

1. Outline how you are going to measure the 'outcome' in your research. Discuss the strengths of your chosen strategy and potential weakness you can foresee. Submit your outline and ideas. 2. Select...

Let's go back to the ongoing case you selected. This will be either your current employer, a specific organization you want to work in, or one of the two hypothetical organizations described in...

Review the following excerpts from journal articles. As you do so, consider the following questions: What is the purpose of the described scale? What do I learn about the development and format of...

The biosynthesis of cholesterol as outlined in Figure 26.10 is admittedly quite complicated. It will aid your understanding of the process if you consider the following questions: (a) Which carbon...

You are given the spot-rate model; dr 1 = ? (k ? r t ) dt + bdW, where the W t , is a Wiener process under the real-world probability. Under this spot rate model, the solution to the PDE that...

As of the end of June, the job cost sheets at Tracer Wheels, Inc., show the following total costs accumulated on three custom jobs. Job 102 was started in production in May and the following costs...

International Business Machines Corp. (IBM) hired Niels Jensen in 2000 as a software sales representative. In 2001, IBM presented a new Software Sales Incentive Plan (SIP) at a conference for its...

Felipe has been leading his company with a learning mindset to improve its ability to innovate. Lately, he has been pushing the boundaries with those inside and outside the company. What skill area...

Endogenous Growth Model (20 points) Consider an economy with a total population of 100. Each individual in this economy accumulates human capital. Each period, a person has one unit of time to split...

Towards the end of the course, we discussed some of the details underlying Classical and Keynesian economics, a seemingly endless debate within the economics profession. In this, we are focusing on...

1. An individual has $4,000 to invest and three opportunities are available to him. Each opportunity requires deposits in $1,000 amounts; the investor may allocate a;; the money to just one...

The Loquat Corporation has book net income of $170,200 for the current year. Included in this figure are the following items, which are reported on the corporation's Schedule M-1, Reconciliation of...

Use the balance sheet and income statement below. VALIUM'S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2024 and 2023 (in millions of dollars). Current assets: Assets Cash and...

You find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15, 2016 The bonds have a par value of $2.000 What price would you...

You are maintaining a subsidiary ledger account for Police-Training Expenditures for 2013. The following columns are used: Inventory purchases are initially recorded as expenditures. Record the...

Refer to Exercise 5.7. Suppose that for each purchase P(B) = 1/2 and the decisions in different weeks are independent. Assign probabilities to the elementary outcomes and obtain the distribution of X.

(a) Evaluate all possible rank configurations associated with treatment A when nA = 3 and nB = 2. (b) Determine the null distribution of WA.

Referring to Exercise 10.51, denote by p1 and p2 the population proportions in the two groups who have In Exercise 10.51 Random samples of 250 persons in the 30- to 40-year age group and 250 persons...

Identify ways to evaluate the quality of a test.

In recent studies, what do some researchers argue is a more accurate means of gauging success in relationships and careers? a. intellectual intelligence b. emotional intelligence c. heredity studies...

While taking a shower, Miguel suddenly realizes the solution to a problem at work. When later asked how he solved this problem, Miguel said, The answer just seemed to pop into my head. Miguels...