MIS775 Decision Modelling for Business Analytics Assignment

Assignment Help Cost Accounting

Reference no: EM132507105

MIS775 Decision Modelling for Business Analytics Assignment - Deakin University, Australia

Assurance of Learning - This assignment assesses following Graduate Learning Outcomes and related Unit Learning Outcomes:

Graduate Learning Outcome (GLO) -

GLO1: Discipline - specific knowledge and capabilities: appropriate to the level of study related to a discipline or profession.

GLO2: Problem solving: creating solutions to authentic (real world and ill-defined) problems.

GLO3: Critical thinking: evaluating information using critical and analytical thinking and judgment.

Unit Learning Outcome (ULO) -

ULO1: Conceptualise, formulate and represent a business problem as a decision model.

ULO2: Develop and solve business problems using advanced decision modelling techniques such as optimisation, stochastic modelling and risk analysis in spreadsheets.

ULO3: Interpret and analyse the results; investigate the sensitivity of the solutions to the assumptions of the decision model.

Background - This assignment is to be completed in groups of 2-3 members. The modelling work should be submitted online in the Assignment Folder as a single MS Excel file with the required information in clearly labelled separate worksheets. In addition, you are also required to submit a MS PowerPoint file that summarises your model and results. In summary, two files should be submitted - an Excel spreadsheet and a PowerPoint file.

The assignment has six sections:

1. Model description, conceptual model, and assumptions

2. Spreadsheet-based decision model

3. Scenario analysis report

4. Stochastic modelling including justification for the choice of distributions

5. Simulated distribution for each output and risk analysis report

6. Overall presentation.

Assignment Details -

You are required to develop a spreadsheet -based decision model that can be used to investigate and explore decisions and risks relating to hotel booking management (and r eservation limits). The model should be designed to be used by the hotel sales manager for accommodation reservation bookings made by customers for the coming high season. You can assume the following:

The number of available rooms is limited.

Cancellations are expected.

The hotel's policy for overbooking is to give customers a free room at another hotel.

Some limits on the number of possible reservations are expected (to handle overbooking).

The decision model must be realistic and easy to use. The level of complexity modelled, for example the choice of deterministic vs. stochastic inputs, input distributions, etc., is left to your discretion. However, the model must enable the user to input the business costs such as maintenance cost, overbooking cost, etc.

No data are provided for this assignment. You are required to create a fictitious client and demonstrate the utility of the decision model using real data where available and create data where it is not.

The minimum requirements of the decision model are:

1. The ability to enter revenue and costs, so that decision options can be explored and to enable outputs, such as profit, to be calculated.

2. Stochastic treatment of some of the inputs, so that the resulting simulated output can be explored.

3. It must also enable the decision maker to explore and understand the risks associated with decision.

Section 1: Model description, conceptual model, and assumptions

Provide a brief overview of the model.

Include a conceptual model.

Note any relevant assumptions.

Section 2: Spreadsheet-based decision model

Design a spreadsheet model that you can use to investigate the problem.

The model should include the following:

Fixed inputs

Stochastic inputs

Decision variables

Calculated variables

Output variables.

Section 3: Scenario analysis report

This section relates to Topic 7. Consider different scenarios for each stochastic input and examine the impact on the outputs.

Section 4: Stochastic modelling including choice of distributions

This section relates to Topic 8. Undertake s tochastic modelling where each of the stochastic inputs are now random. This will require you to choose an appropriate distribution for each of the stochastic inputs, and justify each one.

Section 5: Simulated output distribution and risk analysis report

This section relates to Topic 9. This requires you to examine the simulated distributions for each output, and undertake a risk analysis based on simulation modelling, in order to quantify the risks associated with problem.

Section 6: Overall presentation

The PowerPoint presentation should form the content of a report that includes:

1. A brief description of the model (maximum 100 words)

2. The conceptual model and assumptions behind your decision model.

3. The decision model copied from the spreadsheet.

4. The best and worst case scenarios for the data provided, and a discussion of the consequences.

5. Justification for the choice of distributions.

6. Risk analysis report based on the simulation modelling.

Attachment:- Decision Modelling for Business Analytics Assignment File.rar

Reference no: EM132507105

Questions Cloud

Find the total amount paid of paid- in capital is : A company issued 125 shares of $100 par value common stock for $13500 cash. Find The total amount paid of paid- in capital is

Find the book value per common share is : It also has 21,000 shares of common stock outstanding, and its total stockholders; equity equals $605,400. The book value per common share is

Find the ending balance in retained earnings equals : It had net income of $64,000 and paid out cash dividends of 69,000 in the current period. The ending balance in retained earnings equals.

Which system for dividing the bill is more equitable : Which system for dividing the bill is more equitable? Which system is easier to use? How does this issue relate to the material covered

MIS775 Decision Modelling for Business Analytics Assignment : MIS775 Decision Modelling for Business Analytics Assignment Help and Solution - Deakin University, Australia - Assessment Writing Service

Find how can firms use the budget and other information : Find How can firms use the budget and other information to evaluate the performance of individuals and of the firm. What are some method that can be used.

What are the factory foremen salaries allocated to car seats : What are the factory foremen salaries allocated to Car Seats during the current month? Starbright manufactures children car seats, strollers

How decision of federal reserve bank raise interest rate : How does the decision of the Federal Reserve Bank raise interest rates? Is it to be expected to affect each component of the weighted average cost

How can firms use the budget : How can firms use the budget and other information to evaluate the performance of individuals and of the firm. What are some method that can be used.

User Account

All Pages