Question: You also need to develop a quantitative model (linear programming) using the data, analyse and interpret the model using excel solver and report your findings.
You also need to develop a quantitative model (linear programming) using the data, analyse and interpret the model using excel solver and report your findings. You need to identify an objective function clearly stating the purpose of the quantitative model. You should be able to define the variables under con- sideration for the quantitative model development. Further, you should be to collect relevant information from stakeholders for developing the constraints. The report should outline the stakeholder's analysis for data collection and developing constraints. The devel- oped model should be analysed using the Excel solver function to generate an optimal solution. The report should outline the step-by-step procedure of the solv- er function. The final output should be presented to management for decision analysis. You are required to set up the MS Excel dashboard to assist any user to make decisions. You are to provide quantitative model for managerial decision making with optimal outcomes for the organization by using Excel solver tools and validate the importance of spe- cific analysis and interpretation for the management decisions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
