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")
If you had one slime unit less, the optimum quantity of Blubber Bricks would be?