Question: From the sensitivity report ( Excel) for the variable cells below: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease A 9

  1. From the sensitivity report ( Excel) for the variable cells below:

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

A

9

0

5

1E+30

1.25

B

0

-2

6

2

1E+30

C

0

-2

1

2

1E+30

  1. Which decision variable (s) does appear in the optimal answer ? How many units ?

  1. How much is the optimal solution ( objection function value) ?

  1. What is the range of objective function coefficient so that the optimal answer remains as mentioned above ?

  1. Which decision variable(s) is not used in the optimal answer ? and interpret !

Step by Step Solution

★★★★★

3.36 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The decision variable that appear on the optimal answe... View full answer

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

Q:

(1) Given A and i. (1a) Find the equivalent amount at the end of year 1. (1b) Find the equilvalent amount at the end of year B. (2) Given X and i, Find the annual equivalent A from year S to 8. *...

Q:

Suppose you want to have $300,000 for retirement in 20 years. Your account earns 10% interest. a) How much would you need to deposit in the account each month? $ b) How much interest will you earn?...

Q:

Determine CPI, ETC (1), and EAC. Activity Total PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 6 6 2 20 10 10 3 30 9 6 6 6 3 4 20 8 2 5 5 5 16 4 4 4 4 6 18 9 9 7 8 4 4 Status Report: Ending Period 5 Task %...

Q:

Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each...

Q:

Consider the Flair Furniture example from Sections 4.2 and 4.3. Suppose that the company is considering the option of making stools in addition to its tables and chairs. Stools take 1 hour of...

Q:

Refer to the sensitivity report for Problem 14 in Figure 8.19. a. Interpret the ranges of optimality for the objective function coefficients. b. Suppose that the manufacturing cost increases to...

Q:

Figure 13.35 shows the Solver sensitivity report for the investment. Using only the information in the sensitivity report, answer the following questions. a. How much would the return on stock A have...

Q:

Consider Figure 4.22 from the Hong Kong Bank labor-planning example presented in Solved Problem 41. What would be the impact on daily cost if corporate policy changed to allow the part-time hours to...

Q:

Consider Figure 4.22 from the Hong Kong Bank labor planning example presented in Solved Problem 41. Suppose that every day between 11:00 a.m. and noon, two tellers worth of demand comes from...

Q:

The manager of a large TV store wants to begin stocking a type of remote control device. Expected monthly demand is 800 units. The remote controls can be purchased from either supplier A or supplier...

Q:

What is the rate of return for the investor who pays $1056.14for a three-year bond with a 10% coupon and sells the bond one yearlater for $1020.31 2 answers

Q:

The Plastics Division of Minock Manufacturing currently earns $2.86 million and has divisional assets of $26 million. The division manager is considering the acquisition of a new asset that will add...

Q:

Lauderdale Corporation is organized in three geographical divisions (regions) with managers responsible for revenues, costs, and assets in their respective regions. The firm is highly decentralized...

Q:

1. Look for a written sample of a Deed of Sale, notarized or otherwise. This may be a hard copy, a Word file, JPEG file or a PDF file. 2. From the above document which you have obtained, you should...

Q:

sa Problema 1 A boy riding a bicycle can be modeled as a mass-spring-shock absorber system. The weight of the child is 80N, the constant of elasticity of the spring is 5000 N/m, and the damping...

Q:

Exercise 3.10 3.10 Use the Normal table. Use Table A to find the proportion of observations from a standard Normal distribution that satisfies each of the following statements. In each case, sketch a...

Q:

write a c++ code that generate 500 random real numbers between and including -10 and 10 and graph them by using discrete dots and not continous curves on an imaginery line of y = 1 on XY plane THAT...

Q:

Reduction in sales All of the above 29. Belt of an electric motor is broken, it needs a. Corrective maintenance b. Scheduled maintenance c. Preventive maintenance d. Timely maintenance. 30. The...

Q:

Data on tipping percent for 20 restaurant tables, consistent with summary statistics given in the paper Beauty and the Labor Market: Evidence from Restaurant Servers ( unpublished manuscript by Matt...

Q:

A manufacturing process is designed to produce bolts with a diameter of 0.5 inches. Once each day, a random sample of 36 bolts is selected and the bolt diameters are recorded. If the resulting sample...

Q:

Much concern has been expressed regarding the practice of using nitrates as meat preservatives. In one study involving possible effects of these chemicals, bacteria cultures were grown in a medium...

Q:

Sony Corporation reported the following in the Notes to Consolidated Financial Statements included in the company's 2012 annual report on Form 20-F: Foreign Exchange Forward Contracts and Foreign...

Q:

Where might one find information that could be used to measure the "multi-nationality" of a company?

Q:

What are some of the issues that arise in evaluating and maintaining control over foreign operations?