Need data of a business problem of real-world and idea to find the optimal solution using any optimization model.

The assignment report must address the following three aspects of a company of choice:

1. Identify a business problem of a real-world company. Collect data and estimate the necessary input variables for model formulation.

2. Use one of the following types of optimization models covered in BAN 630 to model the problem on a spreadsheet and find the optimal solution.

a. Linear Programming

b. Integer Programming

c. Nonlinear Programming

d. Decision Tree

e. Simulation Modeling

f. Queueing Models

3. Conduct what-if analyses on the optimal solution. Discuss the impact of variations in the estimates of input variables/constraints and comment on the robustness of the proposed optimal solution. What should be the recommendations for the company management to solve the business problem?