Question: A) Define shadow price and explain each shadow price in a sentence or two B) What is the reduced cost of the bracelet? Show the
A) Define shadow price and explain each shadow price in a sentence or two B) What is the reduced cost of the bracelet? Show the calculation to get this reduced cost. C) If the objective coefficients of the necklace increase by 1, bracelet increase by 1, and ear-stud increase by 1, what's the new profit? Show your calculationsD) If you add 3 units of gold and 2 units of platinum to the current stock, and what is the new profit? E) What are the lower and upper limits of objective coefficients?

Question 2 Use the following reports and answer the questions that follow 5*3=15 marks Input sheet A D E F G 1 X1 Necklace X2 bracelet X3 ear stud 2 10.5 3 3 Max 100 70 40 1450 4 Gold 4 3 60 = 40 Bracelet 1 4 = 3 Answer report 14 Objective Cell (Max) 15 Cell Name Original Value Final Value 16 SE$3 Max 1450 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$2 X1 Necklace 0 10.5 Contin 22 $C$2 X2 bracelet O 4 Contin 23 $D$2 X3 ear stud 0 3 Contin 24 25 26 Constraints 27 Cell Name Cell Value Formula Status Slack 28 $E$4 Gold 50 SESA=$G$5 Binding o w /ol 30 $E$6 Bracelet 4 SE$6=$G$7 Binding Sensitivity report 6 Variable Cells Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$2 X1 Necklace 10.5 LOO 1E+30 6.666666667 10 $C$2 X2 bracelet 0 70 1E+30 11 $D$2 X3 ear stud 3 40 10 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $E$4 Gold 60 26 50 20 15 17 SE$5 Platinum 40 - 2 40 7.5 10 18 SE$6 Bracelet 4 0 7 1E+30 3 19 SE$7 Ear stud 3 -10 3 21 3 20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
