The LP problem whose output follows determines how many necklaces, bracelets, rings and earrings a jewelry store should stock. The objective function measures profit: it is assumed that every piece stocked will be sold. Constraints measure display space in units, time to set up the display in minutes and two marketing restrictions. MAX 100N+120B+150R+1250 N+2B+2R+2E 3N+5B+ E 50 Market Restriction 2 Use the output below to solve and answer the following question. You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1500. What should yo do? Variable Cells Final Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Cell Name Value 8 0 100 1E+30 12.5 $B$18 Necklace $C$18 Bracelet 0 -5 120 5 1E+30 $D$18 Ring 17 0 150 12.5 25 SE$18 Earrings 33 O 125 25 5 Constraints Final Shadow Cell Name Value Price Constraint Allowable Allowable R.H. Side Increase Decrease 15.75 $B$24 Space 108 75 108 8 $B$25 Time 57 0 120 1E+30 63 Restriction $B$26 1 25 25 25 33 17 Restriction $B$27 2 50 -25 50 4 8.5 Just say no because the improvement in your profit for these 15 units is more than $1125 Add the additional units because the improvement in your profit for these 15 units is $1500 Add the additional units because the improvement in your profit for these 15 units is $15 Just say no because the improvement in your profit for these 15 units is only $1125 The LP problem whose output follows determines how many necklaces, bracelets, rings and earrings a jewelry store should stock. The objective function measures profit: it is assumed that every piece stocked will be sold. Constraints measure display space in units, time to set up the display in minutes and two marketing restrictions. MAX 100N+120B+150R+1250 N+2B+2R+2E 3N+5B+ E 50 Market Restriction 2 Use the output below to solve and answer the following question. You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1500. What should yo do? Variable Cells Final Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Cell Name Value 8 0 100 1E+30 12.5 $B$18 Necklace $C$18 Bracelet 0 -5 120 5 1E+30 $D$18 Ring 17 0 150 12.5 25 SE$18 Earrings 33 O 125 25 5 Constraints Final Shadow Cell Name Value Price Constraint Allowable Allowable R.H. Side Increase Decrease 15.75 $B$24 Space 108 75 108 8 $B$25 Time 57 0 120 1E+30 63 Restriction $B$26 1 25 25 25 33 17 Restriction $B$27 2 50 -25 50 4 8.5 Just say no because the improvement in your profit for these 15 units is more than $1125 Add the additional units because the improvement in your profit for these 15 units is $1500 Add the additional units because the improvement in your profit for these 15 units is $15 Just say no because the improvement in your profit for these 15 units is only $1125