Question: Optional part: Consider the graphical solution to the PC Tech product mix model. Now imagine that another constraint-any constraint-is added. Explain your answers to following

Optional part: Consider the graphical solution to the PC Tech product mix model. Now imagine that another constraint-any constraint-is added. Explain your answers to following questions. Do they hold just for this particular model, or do they hold in general? i. Which of the following three things are possible: (1) the feasible region shrinks; (2) the feasible region stays the same; (3) the feasible region expands? ii. Which of the following three things are possible: (1) the optimal value in objective cell decreases; (2) the optimal value in objective cell stays the same; (3) the optimal value in objective cell increases?
 Optional part: Consider the graphical solution to the PC Tech product
mix model. Now imagine that another constraint-any constraint-is added. Explain your answers

c. Optional part: Consider the graphical solution to the PC Tech product mix model. Now imagine that another constraint-any constraint-is added. Explain your answers to following questions. Do they hold just for this particular model, or do they hold in general? i. Which of the following three things are possible: (1) the feasible region shrinks; (2) the feasible region stays the same; (3) the feasible region expands? ii. Which of the following three things are possible: (1) the optimal value in objective cell decreases; (2) the optimal value in objective cell stays the same; (3) the optimal value in objective cell increases? 3- Go back to the PC Tech product mix model. Run Excel Solver and produce Sensitivity Analysis Report. Answer the impact of following changes on your optimal solution using Excel Sensitivity Analysis Report if possible. Notice that this question might not be straightforward. Feel free to rerun Solver if you face a problem that cannot be answered using the sensitivity report you created. You do not have to do that though! Please note that when we are solving the Excel Solver in the class, we used the final version of the model. a. Let the selling price for Basic decrease from $300 to $240. b. Let the labor cost per hour for assembling change from $11 to $20. c. Let the labor hours for testing a Basic change to .5. d. Let the labor hours for testing a Basic change to 3 . e. Let the total availability of assembly hours increase to 10100 . f. Let the total availability of testing hours increase to 3300 . g. Let the max XP requirement be 1180

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!