Analyze Sensitivity Report

a) What is the maximum unit cost that will make it worthwhile to include in the survey persons 30 years of age or younger who live in a border state

b) What is the impact if MSA wants to increase the sample size to 3,000

c) What is the impact if MSA insists on including people 3150 years of age who do not live in a border state

d) What is the impact if we can reduce the minimum 30 or younger persons required to 900, provided that we raise the persons 3150 years of age to 650?

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 Variable Cells Cell Name SBS5 Number of households = 51 and border $E$5 Number of households = 30 and not border $F$5 Number of households 31-50 and not border SGS5 Number of households >= 51 and not border Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.00 0.50 7.50 1 E+30 0.60 600.00 0.00 6.80 0.45 0.82 140.00 0.00 5.50 0.6 29.90 1000.00 0.00 6.90 0.6 0.92 0.00 0.45 7.25 1E+30 0.45 560.00 0.00 6.10 1.025 0.60 Constraints Cell Name SH$8 Total households SH$9 30 households SHS 10 31-50 households SHS11 Border Mexico $HS 12 = 30 and not border SH$13 >= 51 and border Final Value 2300.00 1000.00 600.00 740.00 1000.00 140.00 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 5.98 2300.00 1E+30 700.00 0.92 1000.00 700.00 1000.00 0.82 600.00 700.00 493.75 0.00 0.00 395.0D 1E+30 0.00 0.00 500.00 1E+30 -0.60 0.00 560.00 140.00