1. Click on File, select Data, and click on Solver to get this dialog box:
2. Complete the Sensitivity and Limits Reports. See the following screenshots.
a. Screenshot for steps regarding the Answer and Sensitivity Report:
b. Screenshot for steps regarding the Limits Report:
3. Changes in constraints
a. Screenshot for the scenario about the change in the constraints for tables and chairs:
b. Screenshot for the scenario about the change in the constraints for production time:
4. See the example spreadsheet with data based on the following truck scenario using Solver: