Optimization Modeling
sheyitqan
OptimizationModelingProblemSet.xlsx7-14
| Problem 7-14 | Input the numbers in the beige cells | ||||
| Write formulas to compute values (e.g. profit, resoure utilization) in blue cells | |||||
| Solution | |||||
| AC | FAN | Total | RHS | ||
| Maximize | 0 | ||||
| WIRING TIME | 0 | <= | |||
| DRILLING TIME | 0 | <= |
7-15
| Problem 7-15 | Input the numbers in the beige cells | ||||
| Write formulas to compute values (e.g. profit, resoure utilization) in blue cells | |||||
| Solution | |||||
| AC | FAN | Total | RHS | ||
| Maximize | 0 | ||||
| WIRING TIME | 0 | <= | |||
| DRILLING TIME | 0 | <= | |||
| AC Demand | 0 | >= | |||
| Fan Demand | 0 | <= |
7-18
| 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 | >= | |||
