Reference no: EM132990559

MA609 Business Analytics and Data Intelligence

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 Description:

The assignment is designed to allow you to demonstrate effective business analytics skills using optimisation methods. This requires students to use linear programming skills to formulate and model a problem, and Excel solver will be used to conduct the analytics and obtain the solutions. For the assignment, you are required to form a group of 3-4 students.

CASE 1: PDC which is a small developer business has decided to develop new apartments in either of two different large scale or small scale apartments. The best selection of apartment scale depends on how the marketplace reacts to the economy. To conduct an analysis, marketing management views the possible long- run demand as either low, medium, or high. The following payoff table shows the projected profit in thousands of dollars. Based on the previous data the probability that demand in the economy will turn out to be low, medium, high is 0.2, 0.5, 0.3 respectively.

a. Apply the optimistic, conservative, and opportunity loss approaches to recommend a decision that will maximize the profit.
b. Show influence diagram with decision alternatives, states of nature, and consequences
c. Use decision tree to apply Expected value approach (EV) and show expected value of perfect information (EVPI) when market research will cost the company $5000.
d. Show decision analysis in excel file after applying the approaches.

CASE 2. Each group needs to select a company from the list below and use the company's website to collect some background information and any type of preliminary information that could help in formulating the optimisation problem of the company. You will realise that there is no direct information about optimisation problems of the company that you choose therefore you will need to use the company's background information along with business analytics knowledge to formulate the problem. For instance for an airline the problem could be assignment of terminals, airplanes, flights and pilots. Accordingly and based on the preliminary information that you collect, you need to make assumptions and build up a model for the company and solve the problem.

The problem should be formulated based on Transportation, Transshipment, or Assignment problems (each group selects only one problem and only one company from below list. E.g. Transportation for BHP). As an example you can choose any company in airline or Metro train industries (for assignment problem), in manufacturing or port shipment industries (for transhipment or transportation problem). Below is a list of companies/organisations and possible approaches to problem solving:

Transportation problem by Australian cargo companies:
Australian cargo logistics (Transportation of cargo from origin to destination)
Australian international shipping, cargo and logistics (Transportation of cargo from origin to destination)

Transshipment problem by manufacturing companies:
BMW (Transportation of parts from plants to warehouses and to customers from there) Mazda (Transportation of parts from plants to warehouses and to customers from there)

Assignment problem by sales/servicing companies/organisations:
Virgin airlines (assignment of terminals, airplanes, flights) Metro trains (assignment of trains to different lines) Melbourne children hospital (assignment of surgery theatres)

Assignment structure and requirement:

CASE 1.
a. Apply the optimistic, conservative, and opportunity loss approaches to recommend a decision that will maximize the profit.
b. Show influence diagram with decision alternatives, states of nature, and consequences
c. Use decision tree to apply Expected value approach (EV) and show expected value of perfect information (EVPI) when market research will cost the company $5000.
d. Show decision analysis in excel file after applying the approaches.

CASE2.
a. Selection of the company and introduction to the company and assumptions about the problem and selecting the company before formulating the problem and modelling
b. Model design: Formulation of Liner Programming problem (LP)
» Defining decision variables
» Defining objective functions
» Defining constraints
c. Model implementation:
» Run the analysis and solve the problem using excel solver
d. Interpret the answer sheet and sensitivity analysis sheet in excel solver
e. Recommendation and conclusion
f. Structure and presentation of the assignment
g. Appendix (should include excel solver output)

Presentation
Each group needs to present the findings of the group project. Visual representation takes the form of power point slides and includes one or more of the following: charts, graphs, statistics, pictures, photos or other graphics are used in the power point slides. Presentation will include the power point slides and the video. You must cover relevant items on any required project task and make reference to them. This must include indicating steps for each analytics task. Presentation should also be professional.

The expectation is that every member of the group will present for a few minutes and the total presentation should be 10-15 minutes. Please put the presentation is One Drive or Google Drive and share the link with me so that I can access the presentation.

Attachment:- Business Analytics and Data Intelligence.rar