Write My Paper Button

WhatsApp Widget
Sign in Subscribe

QSO 320 Module Six Linear Programming Solver Document

Jamez

• 2 min read

QSO 320 Module Six Linear Programming Solver Document

 

1.      Click on File, select Data, and click on Solver to get this dialog box:

Screenshot of Solver Parameters dialog

 

 

2.      Complete the Sensitivity and Limits Reports. See the following screenshots.

a.      Screenshot for steps regarding the Answer and Sensitivity Report:

 

Screenshot of Solver Results box. The “Keep Solver Solution” option is selected, the “Sensitivity” report option is highlighted, and the “Outline Reports” box is checked.

 

b.      Screenshot for steps regarding the Limits Report:

 

Screenshot of Solver Results box. The “Keep Solver Solution” option is selected, the “Limits” report option is highlighted, and the “Outline Reports” box is checked.

 

3.      Changes in constraints

a.      Screenshot for the scenario about the change in the constraints for tables and chairs:

 

Screenshot of the Part 3a scenario in the spreadsheet. Fabrication is now limited to 600 minutes, and the minimum number of chairs to be produced is now 16.

 

 

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:

 

Screenshot of the example spreadsheet with data from the truck scenario

Sign up for more like this.

Enter your email
Subscribe