Mixed integer linear programming model| Operation Research
The case has to have be done with excel spreadsheet solver (Mixed Integer Linear Programming Model MILP calculations in excel sheet for the case question) with excel sheet solver firstly, then word file describing in depth the case problem & solution, answering & analysing case question in depth, the answer has to be supported by excel sheet facts to case question to give the right analysis and recommendations.
Giant Motor Company – Mixed Integer Linear Programming Modeling MILP (pp. 350 – 351) has to be looked by an expert in Operations Research field with excellent skills in excel sheet modeling and using solvers.
The source of the subject and assignment is Practical Management Science, W L Winston and S C Albright, Cengage Learning, 4th edition, 2012.
Note: You can find more information and guidelines in the book (Practical Management Science) from pp. 293 – 349.
ASSIGNMENT TASKS
• Examine and present the problem (in word file), formulate it as a spreadsheet (Excel Solver, Mixed Integer Linear programming model MILP calculations for the case question) and determine a solution.
