Chat with us, powered by LiveChat Week 6 assignmentIntroduction to Optimization Mode - Writemia

## 10 Feb Week 6 assignmentIntroduction to Optimization Mode

Week 6 assignmentIntroduction to Optimization Modeling Problem SetManually complete the following problems in the textbook:Problem 7-14Problem 7-15Problem 7-18Use an Excel spreadsheet file for the calculations and explanations Cells should contain the formulas (ie, 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 assignmentMac users can use StatPlus:mac LE, free of charge, from AnalystSoftYou are not required to submit this assignment to TurnitinProblem 7-14 Input the numbers in the beige cells Write formulas to compute values (eg profit, resoure utilization) in blue cells Solution AC FAN Total RHS Maximize 0 WIRING TIME 0 DRILLING TIME 0 Problem 7-15 Input the numbers in the beige cells Write formulas to compute values (eg 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 Problem 7-18 Input the numbers in the beige cells Write formulas to compute values (eg profit, resoure utilization) in blue cells Solution U G Total RHS Maximize 0 Undergrad 0 >= Grad 0 >= Total 0 >=

Do you need an answer to this or any other questions?