Question: 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

The LP problem whose output follows determines
The LP problem whose output follows determines
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 =50 Market Restriction 2 Use the output below to answer the question. You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1500. What should you do? Variable Cells Final Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Cell Name Value $B$18 Necklace 8 0 100 1E+30 12.5 SC$18 Bracelet 0 -5 120 5 1E+30 $D$18 Ring 17 0 150 12.5 25 SES18 Sardines 22 Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18Necklace 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 SE$18 Earrings 33 0 125 25 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 1E430 63 Restriction $B$26 1 25 25 25 33 17 Restriction $B$27 2 50 -25 50 4 8.5 Add the additional units because the improvement in your profit for these 15 units is $15 Add the additional units because the improvement in your profit for these 15 units is $1500 Just say no because the improvement in your profit for these 15 units is only $1125 Just say no because the improvement in your profit for these 15 units is more than $1125

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!