Assignment: Linear Programming Case Study
A beauty salon tries to determine how many bottles of fire red nail polish, bright red nail polish, basil green nail polish, and basic pink nail polish to stock. The profits for each nail polish; assumming that every piece stocked will be sold, are as follows: $100 per bottle of fire red nail polish, $120 per bottle of bright red nail polish, $150 per bottle of basil green nail polish, and $125 per bottle of basic pink nail polish. The display space and set up time requirements are listed in the table. Note that green nail polish does not require any time to prepare its display.
|
Display requirements
|
fire red
|
bright red
|
basil green
|
basic pink
|
available
|
|
Display space (units)
|
1
|
2
|
2
|
2
|
108
|
|
Time to set up a display (minutes)
|
3
|
5
|
|
1
|
120
|
The maximum demand combined for fire red and green polish is 25 bottles, while the minimum demand combined for bright red, green and pink nail polish bottles is at least 50 bottles.
a) Formulate the Linear Programming model for this problem
b) Solve the problem using Excel Solver or QM for Windows
c) How many bottles of fire red nail polish, bright red nail polish, basil green polish and pink nail polish should be stocked?
d) What is the maximum profit?
e) How much space will be left unused?
f) How many minutes of idle time remaining for setting up the display?
g) To what value can the per bottle profit on fire red nail polish drop before the solution would change?
h) By how much can the per bottle profit on green basil nail polish increase before the solution would change?
i) Is it possible for saloon to increase the profit by getting more display space or using more time for setting up the displays?