Question: Question 26 0.33 A specialty retailer has four different styles of umbrellas to stock and wants to maximize profits. assumed that every one stocked will

Question 26 0.33 A specialty retailer has fourQuestion 26 0.33 A specialty retailer has four

Question 26 0.33 A specialty retailer has four different styles of umbrellas to stock and wants to maximize profits. assumed that every one stocked will be sold. The variables measure the number of women's, goli men's, and folding umbrellas, respectively. The constraints measure storage space in units, specia display racks, demand, and a marketing restriction, respectively. MAX 4W+66 + 5M + 3.5F SUBJECT TO 2W + 3G + 3M + F = 12 Marketing Restriction Use the Excel output below to answer the questions that follow. Excel Sensitivity Report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Umbrellas $B$18 Women 12 0 4 1 2.5 Umbrellas $C$18 Golf 0 -0.5 6 6 0.5 1E+30 Umbrellas $D$18 Men 120 5 2.5 0.5 $E$18 Umbrellas Folding 600 3.5 1E+30 0.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$24 Space 120 2 120 48 24 $B$25 Racks 18 0 54 1E+30 36 $B$26 Demand 72 1.5 72 24 48 $B$27 Restriction 12 -2.5 12 12 12 How much space is left unused? 0 48 0 24 2

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!