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.

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. c. 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. 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. c. 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