Question: Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Value: X1 12 0 2 1.00E+30

Microsoft Excel Sensitivity Report

Adjustable Cells

Final

Reduced

Objective

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$C$4

Value: X1

1.00E+30

$D$4

Value: X2

1.00E+30

Constraints

Final

Shadow

Constraint

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$E$10

Used:

1.00E+30

$E$8

Used:

-12

1.00E+30

$E$9

Used:

1.00E+30

Is the optimal solution to this problem unique?

[Without resolving the model] can you tell what will be the optimal solution to this problem if the vaue of the objective function coefficient for variable X1 is zero?

How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?

Given that this is a maximization problem, if management could increase the RHS value for any of the constraints for identical costs, which would you choose to increase and why?

Step by Step Solution

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

A company manufactures and sells two models of lamps, L, and La. To manufacture each lamp, the manual work involved in model L, is 1/3 hour and for L2, 1/2 hour. The mechanical (machine) work...

Considering the following excel sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Product 1= 0 7.5 12 1E+30 7.5...

The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments: (1) Cutting and Coloring. (2) Assembly,...

Question: Please note that this problem has ten parts (a' to "j'). . You may need to scroll the screen down, navigate left and right to see the whole problem. Clearly label your parts when answering....

Question 10 The Furniture City (FC) company makes 3 kinds of couches: (1) Standard, (2) Deluxe, and (3) Luxury styles. Each couch goes through 3 production departments: (1) Cutting and Coloring, (2)...

An investment company currently has $ 1 million dollar available for investment in five different stocks. The company wants to maximize the interest earned over the next year. The five investment...

Data for this month's advertising problem for a certain company is described in the table below: Media Type Number of Cost ($) per Maximum Exposure Customers time unit of an Time Quality Units...

Question 1 part b 20 points for part (b) ABCD company is an office equipment company that produces two types of desks: standard and deluxe. Deluxe desks have oak tops, more expensive hardware, and...

Question 1 part b 25 points for part (b) ABCD company is an office equipment company that produces two types of desks: standard and deluxe. Deluxe desks have oak tops, more expensive hardware, and...

ABCD company is an office equipment company that produces two types of desks: standard and deluxe. Deluxe desks have oak tops, more expensive hardware, and require additional time for finishing and...

1. You are considering adding a new cruise ship to your company's fleet. The cost of th ship is $2,000,000. Your projected increased business and cash flows from having another ship are $300,000 in...

Now you collect a series of intensity/response curves, varying the indentations per second. Make a tuning curve. Estimate the sweet spot. You are making an electrical recording from a sensery...

Of the 200 respondents who were between the ages of 36 and 50, 82 got their news primarily from newspapers. Of the 200 respondents who were above age 50, 104 got their news primarily from newspapers....

You are working out the release planning schedule for the requirements of your project. What is the most important factor to keep in mind for release planning? Select an answer: Release everything at...

2. Now list, after going through a-c, three things that you want to be the impres-sion you want others to be left with after meeting you, and that you want to be lasting over time. List four points...

Relax your shoulders

Keep your head straight on your shoulders