Question: Question 17 0.3 The LP problem whose output follows determines how many necklaces, bracelets, rings, and ea a jewelry store should stock. The objective function

Question 17 0.3 The LP problem whose outputQuestion 17 0.3 The LP problem whose output

Question 17 0.3 The LP problem whose output follows determines how many necklaces, bracelets, rings, and ea a jewelry store should stock. The objective function measures profit; it is assumed that every 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 =50 Market Restriction 2 Use the output below to solve and answer the following questions. 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 5 1E+30 $D$18 Ring 17 0 150 12.5 25 $E$18 Earrings 33 0 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 $B$26 Restriction 1 25 25 25 33 17 $B$27 Restriction 2 50 -25 50 4 8.5 How much will marketing restriction 1 be exceeded? 1 3 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!