Question: Variable Cells Cell $8513 $C$13 $D$13 $E$13 Name DV Marine distributors DV Business distributors DV National retail stores DV Direct mal Final Reduced Objective Allowable

Variable Cells Cell $8513 $C$13 $D$13 $E$13 Name

Variable Cells Cell $8513 $C$13 $D$13 $E$13 Name DV Marine distributors DV Business distributors DV National retail stores DV Direct mal Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 25 0 90 1.00E+30 6 425 84 6 34 150 0 70 17 100E+30 0 -45 60 45 100E +30 0 0 Constraints Cell $85 20 $85 21 $B$ 22 $8$ 23 Name Advertising expenditure Constrain Sales time used Constraint Radios produced Constraint Retail distribution Constraint Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 5000 3 5000 850 50 1775 0 1800 1.00E+30 25 600 60 600 3.571429 85 -17 50 150 150 150 2. The Sensitivity Reports for the Marine Radio problem are given above. We will be looking at the sensitivity report for changing the RHS of a constraint. a. Which are the binding constraints? Give the names, and justify why you say they are binding constraints. b. If the advertising expenditure increases by $400, does the shadow price change? Explain why or why not

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 General Management Questions!