Reference no: EM132524602

MA609 Business Analytics and Data Intelligence - Melbourne Institute of Technology

Learning Outcome 1: Demonstrate advanced and integrated understanding of business and data Intelligence for organisational decision-making.
Learning Outcome 2: Analyse critically, reflect on and synthesise techniques of data visualisation and data mining.
Learning Outcome 3: Demonstrate advanced and integrated understanding of business analytical models.
Learning Outcome 4: Critically analyse, synthesise and reflect on decision analysis techniques to develop optimal strategy.

Assignment requirement:

choose a company from the list or assume your own company make assumptions about the problem before formulating the problem and modelling (assumptions such as the type of operation, amount of manufacturing and shipment, cost, etc.)

Formulate a Linear Programming problem (LP)
After formulating the problem define the following:
Define decision variables
Define objective functions
Define constraints
Implement the model
Run the analysis using Excel solver
Prepare Excel output of the model using excel solver
Run sensitivity analysis using excel solver and interpret the results

Assignment structure:
Introduction to the company
Selection of the company
assumptions about the problem before formulating the problem and modelling
Problem definition
Identification and description of the problem to be analysed
Model design:
Formulation of Linear Programming problem (LP)
Defining decision variables
Defining objective functions
Defining constraints
Model implementation:
Run the analysis using Excel solver
Prepare Excel output of the model using excel solver
Run sensitivity analysis using excel solver and interpret the results
Indication of optimal solution to the problem:
Present solved problem using excel solver
Recommendation and conclusion
Structure and presentation of the assignment
Appendix (should include both assignment word document and Excel solver file)

Note: Students need to submit the assignment as a word document along with the Excel solver file used for the analyses.

Attachment:- Business Analytics and Data Intelligence.rar