QSO 320 Module Six Linear Programming Solver Document

June 14, 2024 1 min read

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:

Expert academic writer and education specialist helping students in the UK, USA, and Australia achieve their best results.

Our expert writers can help you apply everything you've just read — to your actual assignment.