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 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+50+ E 50 Market Restriction 2 Use the output below 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 5 1E+30 SD$18 Ring 17 0 150 12.5 25 SE$18 Earrings 33 0 125 25 5 Constraints Final Shadow Cell Name Value Price Constraint Allowable Allowable R.H. Side Increase Decrease 108 15.75 8 $B$24 Space 108 75 $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 03 0 1 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!