Complete the exercise that asks you to compute other output measures for Simkin’s Hardware Store and include them in the Scenario Manager as described under “Analyzing the Results” for the Scenario Manager for Figure 10.12.

Figure 10.12

Transcribed Image Text:

Results for each scenario are presented in a column. GH Q-14, R-8 has lowest total cost. в D K 2 Scenario Summary Input parameter values for a 3 Current Values: Q8R5 Q8R8 Q10R5 Q10R8 Q12R5 Q12R8 Q14R5 Q14R8 Changing Celis: ST$11 ST$12 5. 8 5 scenario 8 12 8 14 5 6. 10 10 10 12 14 7 8 5 5 8 Result Cells: $2.47 $100.48 S111.64 $44.96 $108.60 $3.05 $43.44 $121.90 S144.60 $177.10 $121.20 $141.10 S105.90 $119.20 $1.77 $1.79 SU$27 SU$28 SU$29 ŞU$30 $2.58 $51.20 $2.20 $91.84 $2.69 $3.54 $83.08 $40.84 $94.90 $104.80 9. $1.39 10 11 12 $221.89 S261.17 $222.19 $223.28 $194.03 S193.87 $165.45 $174.68 $145.59 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each 15 13 Output measure values 14 for a scenario scenario are highlighted in gray.