Week 6
assignment
Introduction to Optimization Modeling Problem Set
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.
Mac users can use StatPlus:mac LE, free of charge, from
AnalystSoft.
You are not required to submit this assignment to Turnitin.
|
Problem 7-14 |
Input the numbers in the beige |
|||||
|
Write formulas to compute values |
||||||
|
Solution |
||||||
|
AC |
FAN |
Total |
RHS |
|||
|
Maximize |
0 |
|||||
|
WIRING TIME |
0 |
<= |
||||
|
DRILLING TIME |
0 |
<= |
||||
|
Problem 7-15 |
Input the numbers in the beige |
|||||
|
Write formulas to compute values |
||||||
|
Solution |
||||||
|
AC |
FAN |
Total |
RHS |
|||
|
Maximize |
0 |
|||||
|
WIRING TIME |
0 |
<= |
||||
|
DRILLING TIME |
0 |
<= |
||||
|
AC Demand |
0 |
>= |
||||
|
Fan Demand |
0 |
<= |
||||
|
Problem 7-18 |
Input the numbers in the beige |
|||||
|
Write formulas to compute values |
||||||
|
Solution |
||||||
|
U |
G |
Total |
RHS |
|||
|
Maximize |
0 |
|||||
|
Undergrad |
0 |
>= |
||||
|
Grad |
0 |
>= |
||||
|
Total |
0 |
>= |
||||
