MBAMS 638 Assignment 6
Page 1 of 1
Consider one of the managerial decisions you mentioned for your dream company in
Assignment 1. You can also consider a new managerial decision for your dream
a) Describe the problem in words (objective, parameters, constraints, etc.)
b) Define the decision variables.
c) Formulate the problem as a linear programming (LP) model.
d) Use Excel Solver to solve the associated LP model and find the optimal solution.
Ask Excel to generate the Answer report.
e) Interpret the result. For example, what are the optimal values of decision
variables? Which resources are totally consumed (binding constraints)?
f) Do sensitivity analysis on one of the right-hand sides and one of the objective
Note: You should submit one Word file for parts (a), (b), (c), and (e) and one Excel file
for part (d) (you can create several sheets in the Excel file).
The post MBAMS 638 Assignment 6 appeared first on My Assignment Online.