In: Statistics and Probability
Toys Insane Inc. produces two goods: Glibber Gems (G) and Blubber Bricks (B). In order to produce Glibber Gems and Blubber Bricks, three input factors are necessary: Slime (S), Tran (T), and Gorilla Mucus (M). The following table summarizes how many input factors are necessary to produce one unit of each good and how many input factors are available in total:
Glibber Gems |
Blubber Bricks |
Total Units Available |
|
Slime Units |
1 |
2 |
14 |
Tran Units |
3 |
4 |
36 |
Gorilla Mucus Units |
9 |
6 |
90 |
The unit profits for each Glibber Gem and Blubber Brick are each $5.
Please program the linear programming model using Excel's "Solver (Please check "Make Unconstrained Variables Non-Negative")
By how much could the unit profit of Blubber Bricks increase before the optimum solution changes?
This is the repeated ques .. i had already answer it
By analysing the constraints i found that the the unit profit decreased from 3 to 0 when the optimum solution changes.
we can easily infer the unit profit from these two images and see how the optimal solution affects.