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 - and assuming that you cannot produce non-integer numbers of Glibber Gems and Blubber Bricks - then the optimum number of Blubber Bricks would be?