Question 2 5 pts U 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+125E N+23+2R+2E 3N+5B+ E 50 Market Restriction 2 Use the output to solve and answer the following question. By how much will marketing restriction 1 be exceeded? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18 Necklace B 0 100 1E+30 12.5 SC$18 Bracelet 0 -5 120 5 1E+30 SD$18 Ring 17 0 150 12.5 25 SE$18 Earrings 33 o 125 25 5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$24 Space 108 75 108 15.75 SBS25 Time 57 0 120 1E+30 63 Restriction 1 SBS26 25 25 25 33 17 Restriction SB$272 50 -25 50 8.5 B+R+ E >50 Market Restriction 2 Use the output to solve and answer the following question. By how much will marketing restriction 1 be exceeded? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18 Necklace 8 0 100 1E+30 12.5 $C$18 Bracelet 0 -5 120 S 1E+30 SD$18 Ring 17 0 150 12.5 25 SE$18 Earrings 33 0 125 25 5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$24 Space 108 75 108 15.75 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 0 1 O 3 00 04