How to determine an optimal solution that will maximize the organization’s objectives

Optimizing Performance: Finally, you will determine an optimal solution that will maximize the organization’s objectives. You will need to consider the level of sensitivity and uncertainty of alternative solutions in supporting your optimal solution. The analyses need to be submitted in an annotated excel file and include a rationale.

A. Determine the values of the constraints to be used to generate the target number when running Solver.

B. Using Solver, calculate the level of sensitivity of decision variables and describe the significance of the report.

C. Using Solver, calculate the limits of decision variables and describe the significance of the report.

D. Discuss solutions that will maximize profits for the organization based on the Solver analysis.