Question 2
mrsaiz
Prb4_14_empty_Solver.xlsxModel
| Nutrient (in ounces) per pound of feed | |||||||||||||
| Nutrient | Feed 1 | Feed 2 | Feed 3 | Available | Req'd Pounds | Req'd Ounces | Max Ounces | ||||||
| A | 3 | 2 | 4 |
BIT: Constraint cell | 4 | 64 | 128 | ||||||
| B | 3 | 1 | 3 |
BIT: Constraint cell | 5 | 80 | 160 | ||||||
| C | 1 | 0 | 2 |
BIT: Constraint cell | 1 | 16 | 32 | ||||||
| D | 6 | 8 | 4 | 8 | 128 | 256 | |||||||
| Cost per lb | $2.00 | $2.50 | $3.00 | ||||||||||
| Pounds per cow per mo | |||||||||||||
|
BIT: Variable cells |
BIT: Constraint cell |
BIT: Variable cells |
BIT: Objective cell |
BIT: Variable cells | Max Available | 15 | 15 | 15 |
Beef-Up Ranch
Spider Plot
| Nutrient (in ounces) per pound of feed | |||||||||||||
| Nutrient | Feed 1 | Feed 2 | Feed 3 | Available | Req'd Pounds | Req'd Ounces | Max Ounces | ||||||
| A | 3 | 2 | 4 |
BIT: Constraint cell | 4 | 64 | 128 | ||||||
| B | 3 | 1 | 3 |
BIT: Constraint cell | 5 | 80 | 160 | ||||||
| C | 1 | 0 | 2 |
BIT: Constraint cell | 1 | 16 | 32 | ||||||
| D | 6 | 8 | 4 | 8 | 128 | 256 | |||||||
| Cost per lb | ERROR:#NAME? | ERROR:#NAME? | ERROR:#NAME? | ||||||||||
| Pounds per cow per mo | |||||||||||||
|
BIT: Variable cells |
BIT: Constraint cell |
BIT: Variable cells |
BIT: Objective cell |
BIT: Variable cells | Max Available | 15 | 15 | 15 | |||||
| Base Case Cost per lb | $2.00 | $2.50 | $3.00 |
Beef-Up Ranch
