Details:
Manually complete the following problems in the textbook:
- Problem 7-14
- Problem 7-15
- Problem 7-18
Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Students are highly encouraged to use the “Optimization Modeling Problem Set” Excel resource to complete this assignment.
| Problem 7-18 | Input the numbers in the beige cells |
|||||||||
| Write formulas to compute values (e.g. profit, resoure utilization) in blue cells |
||||||||||
| Solution | ||||||||||
| U | G | Total | RHS | |||||||
| Maximize | 0 | |||||||||
| Undergrad | 0 | >= | ||||||||
| Grad | 0 | >= | ||||||||
| Total | 0 | >= | ||||||||
Categories: