Use Excel charts to visualize the solution for the Sklenka Skis example that we discussed in Chapter 13 and in this chapter. Use the Solver Answer Report (Figure 13.5) and the Sensitivity Report (Figure 15.3). Use the Sklenka Skis Excel file to generate these reports and facilitate your analysis.

a) bar chart for decision variables,

b) column chart for constraints,

c) stacked column chart for reduced cost,

d) stock chart for Range of Optimality, (Note: Excel will not generate a stock chart if there are only two series of data. Please add a dummy decision variable with 0 for Minimum, Current, and Maximum.)

e) stock chart for Range of Feasibility,

f) column chart for shadow prices.