Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Project Management

Authors: Kathy Schwalbe

6th Edition

978-111122175, 1133172393, 9780324786927, 1111221758, 9781133172390, 324786921, 978-1133153726

More Books

Students also viewed these General Management questions

Question

What is the Easterlin Paradox?

Answered: 1 week ago