Question 2 Use the following reports and answer the questions that follow 5*3=15 marks Input sheet A B C D E F G 1 X1 Necklace X2 bracelet X3 ear stud 2 10.5 4 3 3 100 70 40 1450 4 Gold 4 2 60 = 40 A 1 6 Bracelet 4 = 3 7 Ear stud Answer report 14 Objective Cell (Max) 15 Cell Name Original Value Final Value 16 SE$3 Max 0 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 4 Contin $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 30 $E$6 Bracelet 4 SE$6=$G$7 Binding 0 Sensitivity report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 X1 Necklace 10.5 0 100 LE+30 6.666666667 10 $C$2 X2 bracelet 0 70 5 1E+30 11 $D$2 X3 ear stud 3 0 40 10 LE+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $E$4 Gold 50 26 60 20 15 17 SE$5 Platinum 10 - 2 40 7.5 10 18 $E$6 Bracelet 4 0 7 18+30 3 19 SE$7 Ear stud 3 -10 3 21 3 20 -Aa) Define shadow price and explain each shadow price in a sentence or two. 2b) What is the reduced cost of the bracelet? Show the calculations to get this reduced cost. 2c) If the objective coefficients of the necklace increase by 1, bracelet increase by 1, and ear-stud increase by 1, what is the new profit? Show your calculations. 2d) If you add 3 units of gold and 2 units of platinum to the current stock, what is the new profit? 2e) What are the lower and upper limits of objective coefficients? UI