Answered step by step
Verified Expert Solution
Question
1 Approved Answer
XYZ Manufacturer produces different smartphones which are sold to mobile phone stores. The smartphone models are: Economy (x1), Standard (x2), Deluxe (x3). The following
XYZ Manufacturer produces different smartphones which are sold to mobile phone stores. The smartphone models are: Economy (x1), Standard (x2), Deluxe (x3). The following LP model is to maximize total profits: Maximize 80x1+130x2 + 200x3 Subject to 6x18x2+12x3 The Excel Sensitivity Report is as follows: Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease Model of Economy (x1) 118 ? 80 17.37 19.62 Model of Standard (x2) 64 ? 130 10.69 22 Model of Deluxe (x3) 23 ? 200 103.57 12.57 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Material #1 Used 1500 8.38 1500 282.61 180.07 Material #2 Used 1365 0 1500 1E+30 13.37 Material #3 Used 1500 1.31 1500 441.51 219.59 Manufacturing Time Used 10260 0 24000 1E+30 13739.80 Assembly Time Used 8500 0.93 8500 566.18 1525 Material #2 Used 1365 0 1500 1E+30 135.37 Material #3 Used 1500 1.31 1500 441.51 219.59 Manufacturing Time Used 10260 0 24000 1E+30 13739.80 Assembly Time Used 8500 0.93 8500 566.18 1525 What is the total profit? What is the reduce cost for Standard Model? Which constraints are binding? XYZ Company would like to replace some machines used for manufacturing. The new machines will only have a total capacity of 11,000 minutes. This change will reduce the optimal values of this decision variables. Is the statement correct? Why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started