Description
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.
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
Maximize
WIRING TIME
DRILLING TIME
FAN
Total
0
0
Purchase answer to see full
attachment
Input the numbers in the beige cells
Write formulas to compute values (e.g. profit, resoure utilization) in blue cells
Solution
AC
Maximize
WIRING TIME
DRILLING TIME
FAN
Total
0
0
Purchase answer to see full
attachment
Categories: