Reference no: EM132217623
Assessment – Sensitivity Analysis
In a product-mix-problem, X1, X2, X3, and X4 indicate the units of products 1, 2, 3, and 4, respectively, and the linear programming model is
MAX Z = $15X1+$17X2+$18X3+$16X4
S.T.
1) 5X1+3X2+8X3+4X4 <=1600 Machine A hours
2) 7X1+8X2+7X3+6X4 <= 1700 Machine B hours
3) 2X1+9X2+1X3+2X4 <= 1800 Machine C hours
4) 6X1+2X2+6X3+5x4 <= 1900 Machine D hours
Input the data in an Excel file and save the file. Using Solver, solve the problem and obtain sensitivity results.
Questions:
What is the value of maximum profit?
Which constraints are binding and what does it mean?
Which machines have excess capacity available? How much?
If the objective function coefficient of X1 is increased by $0.50, will the optimal solution change? What would be the new value of the objective function?
Suppose the objective function coefficient of X1 is increased by 0.80, the objective function coefficient of X2 is decreased by 1.1, and the objective function coefficient of X4 is increased by 0.4, what will be the new optimal solution and the value of the objective function? Explain and show your computations to support your answer.
What should be the contribution of product 4, so it will be profitable to produce? Explain.
Seven hundred additional hours for Machine B can be obtained at 1.10 above the current cost. Should the additional hours be obtained at the quoted cost? Why or why not? Fully explain. If the 500 additional Machine A hours are obtained, what will be the net increase in profits?
One hundred additional hours for Machine A can be obtained free of charge. Should the additional hours be obtained? Why or why not? Fully explain.
|
Discuss how you should conduct effective interviews
: If you are or were an HR professional or a manager, discuss how you should conduct effective interviews.
|
|
Share your thoughts on both blogs and podcasts
: Share your thoughts on both blogs and podcasts, and the different ways to communicate during meetings and events, giving examples of how you will use them.
|
|
Demonstrate high relationship conflict-interpersonal tension
: Team members that demonstrate high relationship conflict and interpersonal tensions are more likely to conflict intensely and will be associated with performanc
|
|
Internal audit functions in the development of the code
: Explain why it is important to include representatives from the legal, human resources, and internal audit functions in the development of the code.
|
|
Sensitivity analysis-what is the value of maximum profit
: In product-mix-problem, X1, X2, X3, and X4 indicate the units of products 1, 2, 3 and 4, respectively and linear programming model is.
|
|
Manage risk and increase agricultural efficiency
: Which of the following is prompting farmers in many developed nations to discover new ways to manage risk and increase agricultural efficiency?
|
|
What does the asia pacific regions hospitality landscape
: What does the Asia Pacific regions hospitality landscape look like? Homogeneous? Heterogeneous? Explain.
|
|
Discuss the role of unions in the history of american labor
: Discuss the role of unions in the history of American labor. Are unions today good, bad, or needed for companies?
|
|
A derived class is generally smaller than its base class
: In some programming languages, such as C#, Visual Basic, and Java, every class you create is a child of one ultimate base class, often called.
|