Consider the cell phone manufacturing problem presented in Chapter3 as Problem 3-6 on page 105.Use Solver to create the Sensitivity Report for this LP problem. Use this report to answer the following questions. Each question is independent of the others.

(a) Interpret the reduced costs for the products that are not currently included in the optimal production plan

(b) Another part of the corporation wants to take 35 hours of time on test device 3. How does this affect the optimal solution?

(c) The company has the opportunity to obtain 20 additional hours on test device 1 at a cost of $25 per hour. Would this be worthwhile?

(d) The company has the opportunity to give up 20 hours of time on device 1 and obtain 40 hours of time on device 2 in return. Would this be worthwhile? Justify your answer

a. Interpret the reduced costs for the products that are not currently included in the optimal production plan. Microsoft Excel 14.0 Sensitivity Report Problem 4-13. Win Big Gambling Club Variable Colls Cell Name $B$5 Number of units TV spots $C$5 Number of units Newspaper ads $D$5 Number of units Prime-time radio spots SE$5 Number of units Attomoon radio spots Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1.97 0.00 5000.00 1620.69 5000.00 5.00 0.00 8500.00 1E-30 2718.75 6.21 0.00 2400.00 1E-30 263.16 0.00 -344.83 2800.00 344.83 1E+30 Constraints Cell Name SF58 Maximum TV SFS9 Maximum newspaper SFS10 Max prime-time radio $F$11 Max afternoon radio $F$12 Total budget $F513 Maximum radio S SF514 Minimum radio spots Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 1.97 0.00 12 001 1E30 10.03 5.00 2718 75 5.00 1.70 5.00 6.21 0.00 25.00 1E+30 18.79 0.00 0.00 20.00 1E+30 20.00 8,000.00 6.25 8000.00 8025.00 1575.00 1,800.00 2.03 1800.00 1575.00 350.00 6.21 0.00 5.00 1.21 1E+30 Screenshot 4-6 Solver Sensitivity Report for Problem 4-13: Win Big Gambling Club Microsoft Excel 14.0 Sensitivity Report Problem 4.14. Management Science Associates Vanable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 5655 Number of households = 51 and border 140.00 0.00 5.50 0.6 29.90 SES5 Number of households 30 and not border 1000.00 0.00 6.90 0.6 0.92 $F$5 Number of households 31-50 and not border 0.00 0.45 7.25 1E+30 0.45 SGS5 Number of households >= 51 and not border 560.00 0.00 6.10 1.025 0.50 Constraints Cell Name SHS8 Total households SH$9 30 households 9 SHS10 31-50 households SHS11 Border Mexico SHS 12 = 51 and border $ Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 2300.00 5.98 2300.00 1E+30 700.00 1000.00 0.92 1000.00 700.00 1000.00 600.00 0.82 600.00 700.00 493.75 740.00 0.00 0.00 395 00 1E+30 1000.00 0.00 0.00 500 001 1E+30 140.00 -0.60 0.00 560.00 140.00 Screenshot 4-7 Solver Sensitivity Report for Problem 4-14: MSA Marketing Research