Reference no: EM133577082

Question: Optimizing Performance: Finally, you'll decide on an optimal solution that will maximize the organization's objectives. You'll need to think about the level of sensitivity and uncertainty of other solutions in supporting your optimal solution. The analyses need to be submitted in an annotated Excel file and include your reasoning. Decide on the values of the constraints to be used to generate the target number when running Solver. Using Solver, calculate the level of sensitivity of decision variables and explain the importance of the report. Using Solver, calculate the limits of decision variables and explain the importance of the report. Identify solutions that will maximize profits for the organization based on the Solver analysis.