Sklenka Ski Company (SSC) is a small manufacturer of two types of popular all-terrain snow skis, the Jordanelle and the Deercrest models. View more information about the manufacturing process and the two ski models here. The company wants to determine how many of each model should be produced on a daily basis to maximize net profit. Use Excel charts to visualize the solution. Use the accompanying Solver Answer Report and Sensitivity Report. Click here to view the given information and the required spreadsheet model. Click here to view the Solver Answer Report. Click here to view the Solver Sensitivity Report. Construct a visualization for the values of the optimal decision. Choose the correct chart below. A. B. C. D. Excel Solver Answer Report Excel Solver Answer Report Excel Solver Sensitivity Report Objective Cell (Mau) . Construct a visualization that shows the resources used and not used. Choose the correct chart below. Click here to view chart b. Click here to view chart d. Click here to view chart c. Click here to view chart a. Chart b Chart d Chart c Chart a Construct a chart to visualize the ranges over which the constraints may change without changing the optimal values of the decision variables. Choose the correct chart below, where black circles represent the current values, red triangles represent the minimum values, and blue squares represent the maximum values. Click here to view chart e. Click here to view chart h. Click here to view chart f. Click here to view chart g. Chart e Chart h Chart f Chart g Sklenka Ski Company Information and Spreadsheet Model Sklenka Ski Company Information and Spreadsheet Model Solver parameters are given below. Use the Simplex LP solving method. Set Objective: $D$22 To: Max By Changing Variable Cells: $B$14:$C14 Subject to the Constraints: $D15=0 Make sure that the Make Unconstrained Variables Non-Negative box is checked. Sklenka Ski Company (SSC) is a small manufacturer of two types of popular all-terrain snow skis, the Jordanelle and the Deercrest models. View more information about the manufacturing process and the two ski models here. The company wants to determine how many of each model should be produced on a daily basis to maximize net profit. Use Excel charts to visualize the solution. Use the accompanying Solver Answer Report and Sensitivity Report. Click here to view the given information and the required spreadsheet model. Click here to view the Solver Answer Report. Click here to view the Solver Sensitivity Report. Construct a visualization for the values of the optimal decision. Choose the correct chart below. A. B. C. D. Excel Solver Answer Report Excel Solver Answer Report Excel Solver Sensitivity Report Objective Cell (Mau) . Construct a visualization that shows the resources used and not used. Choose the correct chart below. Click here to view chart b. Click here to view chart d. Click here to view chart c. Click here to view chart a. Chart b Chart d Chart c Chart a Construct a chart to visualize the ranges over which the constraints may change without changing the optimal values of the decision variables. Choose the correct chart below, where black circles represent the current values, red triangles represent the minimum values, and blue squares represent the maximum values. Click here to view chart e. Click here to view chart h. Click here to view chart f. Click here to view chart g. Chart e Chart h Chart f Chart g Sklenka Ski Company Information and Spreadsheet Model Sklenka Ski Company Information and Spreadsheet Model Solver parameters are given below. Use the Simplex LP solving method. Set Objective: $D$22 To: Max By Changing Variable Cells: $B$14:$C14 Subject to the Constraints: $D15=0 Make sure that the Make Unconstrained Variables Non-Negative box is checked