Question 13 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+2B+2R+2E 3N+5B+ E 50 Market Restriction 2 Use the output to solve and answer the following question. How many necklaces, bracelets, rings, and earrings should be stocked Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$18 Necklace 8 0 100 1E-30 125 $C$18 Bracelet 0 5 120 5 LE+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 1E30 63 Restriction SBS26 1 25 25 25 33 17 Restriction SB$27 2 50 -25 50 4 8.5 N+ R 50 Market Restriction 2 B+R+ E Use the output to solve and answer the following question. How many necklaces, bracelets, rings, and earrings should be stocked Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18 Necklace 8 0 100 1E+30 12.5 SC$18 Bracelet 0 -5 120 5 1E430 $D$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 D 120 1E+30 63 Restriction $B$26 1 25 25 25 33 17 Restriction $B$27 2 50 -25 50 4 8.5 O 0, 17, 33.8 O 0,8, 17,33 O 33, 17, 8,0 8,0, 17,33