Consider Figure 4.16, which shows the Sensitivity Report for the Anderson Home Electronics example in Section 4.4. Use the Sensitivity Report to answer the following questions, if possible. Each question is independent of the other questions.

(a) What is the impact of a 300-unit decrease in the supply of electronic components?

(b) What is the impact if the profit margin of the Satellite Radio Tuner decreases by $2.00?

(c) What is the impact if the profit margin of the Satellite Radio Tuner increases by $10.00?

(d) What is the impact if the profit margin of the LCD TV decreases by $2.00?

(e) What is the impact if the profit margin of the Blue-Ray DVD player decreases by $10.00?

Figure 4.16

Transcribed Image Text:

Microsoft Excel 14.0 Sensitivity Report Worksheet: (Figure 4.14.xlsxJAnderson Home Electronics For changes to OFC values in this range, current solution remains optimal. Variable Cells Allowable Final Reduced Objective Allowable Allowable Value 0.00 380.00 Coefficient Increase Decrease -1.00 Cell Name Cost decrease is SBS5 Solution value MP3 Player SCS5 Solution value Satellite Radio Tuner SD$5 Solution value LCD TV SES5 Solution value Blu-Ray DVD Player 1060.00 29.00 1E+30 infinity since product is not 1.00 0.00 32.00 40.00 1.67 attractive even 1E+30 5.00 0.00 -8.00 72.00 8.00 at current 0.00 54.00 10.00 OFC value. Constraints Final Shadow Constraint Allowable Allowable Cell Name Value 4700.00 3940.00 2500.00 Price SFS 10 Electronic components SFS11 Non-electronic components SFS 12 Assembly time R.H. Side Increase Decrease 4700.00 4500.00 2500.00 950.00 560.00 1325.00 2.00 2800.00 1E+30 466.67 0.00 24.00 Since non-electronic components are nonbinding, shadow price is zero. The allowable increase is infinity since there are already 560 units of slack.