[All Steps] The following output represent a problem whose solution will tell a specialty retailer how many of four different styles of umbrellas to stock
Question: The following output represent a problem whose solution will tell a specialty retailer how many of four different styles of umbrellas to stock in order to maximize profit. It is assumed that everyone stocked will be sold. The variables measure the number of women's, golf, men's, and folding umbrellas, respectively. The constraints measure storage space in units, special display racks, demand, and a marketing restriction, respectively.
Use the output on the next page to answer the questions.
- How many women's umbrellas should be stocked?
- How many golf umbrellas should be stocked?
- How many men's umbrellas should be stocked?
- How many folding umbrellas should be stocked?
- How much space is left unused?
- How many racks are used?
- By how much is the marketing restriction exceeded?
- What is the total profit?
- By how much can the profit on women's umbrellas increase before the solution would change?
- To what value can the profit on golf umbrellas increase before the solution would change?
- By how much can the amount of space increase before there is a change in the dual price?
- You are offered an advertisement that should increase the demand constraint from 72 to 86 for a total cost of $20. Would you say yes or no?
MAX 4 X1 + 6 X2 + 5 X3 + 3.5 X4
SUBJECT TO
ii) 2 X1 + 3 X2 + 3 X3 + X4 <= 120
iii) 1.5 X1 + 2 X2 <= 54
iv) 2 X2 + X3 + X4 <= 72
v) X2 + X3 >= 12
END
OBJECTIVE FUNCTION VALUE
- 318.00000
| Variable | Value | Reduced Cost |
| X1 | 12.000000 | .000000 |
| X2 | .000000 | .500000 |
| X3 | 12.000000 | .000000 |
| X4 | 60.000000 | .000000 |
| Row | Slack or Surplus | Dual Price |
| 2) | .000000 | 2.000000 |
| 3) | 36.000000 | .000000 |
| 4) | .000000 | 1.500000 |
| 5) | .000000 | -2.500000 |
RANGES IN WHICH THE BASIS IS UNCHANGED:
| Obj . Coefficient Ranges | |||
| Variable |
Current
Coefficient |
Allowable
Increase |
Allowable
Decrease |
| X1 | 4.000000 | 1.000000 | 2.500000 |
| X2 | 6.000000 | .500000 | Infinity |
| X3 | 5.000000 | 2.500000 | .500000 |
| X4 | 3.500000 | Infinity | .500000 |
| Righthand Side Ranges | |||
| Row |
Current
RHS |
Allowable
Increase |
Allowable
Decrease |
| 2 | 120.000000 | 48.000000 | 24.000000 |
| 3 | 54.000000 | Infinity | 36.000000 |
| 4 | 72.000000 | 24.000000 | 48.000000 |
| 5 | 12.000000 | 12.000000 | 12.000000 |
Deliverable: Word Document 