联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codehelp

您当前位置:首页 >> C/C++程序C/C++程序

日期:2020-09-28 08:44

MIS275 – Decision Analytics Assignment 2 – Trimester 2, 2020 Page 1
DEAKIN BUSINESS SCHOOL
DEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS
MIS275 Decision Analytics
Assignment Two: Simulation of Technology Project Selection
Background
This is an individual assignment. 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 report that summarises your models and results. Your report must be in MS Word file
format. Any other file format, such as pdf, is NOT acceptable and will not be marked. In summary, two files
should be submitted – one MS Excel spreadsheet and one MS Word file.
The assignment has six sections:
1. Model description, conceptual model, and assumptions
2. Spreadsheet-based deterministic decision model
3. Scenario analysis
4. Spreadsheet-based stochastic decision model including justification for the choice of distribution
5. Simulated distribution for each output and a risk analysis
6. Report.
The requirements of each section are detailed below. The breakdown of marks (total is 30) is given in the
Assignment 2 Rubric at the end of this document.
Percentage of final grade 30%
Due date Sunday 27 September 2020 at 8pm AEDT
The assignment must be submitted by the due date electronically in CloudDeakin. When submitting
electronically, check that you have submitted the work correctly by following the instructions. Please note that
we will NOT accept any assignment or part of the assignment submitted after the deadline or via Email.
Any request for an extension must be negotiated at least one week prior to the above deadline by email. Deakin
policy for late submission: 5% will be deducted from the 30 marks allocated to this assessment task for each
day or part day that the assessment is late, up to five days. Penalties also apply on weekend days and public
holidays. When work is submitted more than five days after the due date, the task will not be marked, and the
student will receive 0% for the task.
Assurance of Learning
This assignment assesses following Graduate Learning Outcomes and related Unit Learning Outcomes:
Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO)
GLO1: Discipline-specific knowledge and
capabilities: appropriate to the level of study
related to a discipline or profession.
GLO3: Digital literacy: using technologies to find,
use and disseminate information
GLO4: Critical thinking: evaluating information
using critical and analytical thinking and judgment
ULO1: Apply decision models optimisation techniques to
conceptualise and
represent a business scenario
ULO2: Apply optimisation software tools to find optimal
decisions for a given business scenario
ULO3: Interpret and analyse the results; investigate the
assumptions of the decision model
Feedback
Prior to submission
Students are able to seek assistance from the teaching staff to ascertain whether the assignment conforms to
submission guidelines. Please post your questions on CloudDeakin’s discussion forum for Assignment 2.
After submission
Your assignment feedback will be returned in the rubric via CloudDeakin with an overall mark and comments.
MIS275 – Decision Analytics Assignment 2 – Trimester 2, 2020 Page 2
Assignment Details:
Acme Group Inc. is a multinational strategy consultancy with global headquarters in Melbourne, Australia.
The company offers strategic solutions to its clients and has an annual revenue of $500M. In order to
maintain their competitive position in the marketplace Acme Group needs to continually look for
opportunities to invest in new technologies. The Chief Information Officer, Jane Porter, is currently
considering twelve technology proposals put forth by three divisions within the Group – Marketing, R&D,
and HR.
A number of the proposals are for joint projects, to be undertaken with partner organisations which Acme
Group has well-established strategic alliances.
Each division has provided Jane with the capital expenditures required for each project over the next three
years and, based on the expected revenue to be generated by each project, the NPV of each project as shown
below, and the ownership %.
Project
no.
Division Ownership
%
Capital expenditure* ($M) NPV* ($M)
Year 1 Year 2 Year 3
1 Marketing 100% 2.5 1.0 1.0 0.6
2 Marketing 33% 5.0 3.0 3.0 1.8
3 Marketing 50% 1.0 2.0 4.0 0.8
4 Marketing 100% 7.5 5.0 3.0 3.1
5 Marketing 75% 2.0 4.0 8.0 2.2
6 R&D 50% 10.0 3.0 3.0 1.8
7 R&D 100% 7.5 7.5 3.0 4.1
8 R&D 100% 8.0 7.0 6.0 2.8
9 R&D 67% 4.0 6.0 8.0 3.8
10 HR 100% 1.0 2.0 4.0 1.0
11 HR 50% 7.0 5.0 3.0 2.6
12 HR 100% 15.0 4.0 4.0 3.4
*The capital expenditures and NPV for each project are subject to the ownership %. For example, should project 5 be funded, capital
expenditures for the Acme Group will amount to 75% of the stated figures, or $1.5M, $3.0M, and $6.0M over the three years, for an
NPV of $1.65M. The other quarter of the expenditures will be funded by a strategic ally, which will be entitled to quarter of the
stated NPV. By contrast, the Acme Group will provide 100% of the required capital expenditures for project 1, for a NPV of $0.6M.
The CEO, Edgar Burroughs, after consulting with the Chief Financial Officer, John Clayton, has given Jane an
overall three-year budget of $100 million for the set of projectsshe approves, with a maximum of $40 million
available in any one year.
Jane has now tasked you with developing a spreadsheet‐based decision model that can use to explore the
twelve investment alternatives and their associated risks.
As a starting point, she wants you to develop a spreadsheet model using the Deterministic model worksheet
provided in the assignment spreadsheet. This worksheet has four sections: Inputs, Decisions, Calculated
values, and Summary values and Outputs.
Jane wants the spreadsheet to automatically update all tables and results each time she the enters 0s and
1s in cells O26:O37. In that way, so can see the results for any set of projects that she wants to consider
funding.
MIS275 – Decision Analytics Assignment 2 – Trimester 2, 2020 Page 3
The information that Jane is particularly interested in is the following:
1. Number of projects undertaken in each division
2. Capital expenditures ($M) - company wide and by division. Jane also wants to see the calculated
values in cells P26:AA37, in case she needs to see a full breakdown of capital expenditure.
3. Whether any expenditure limits are exceeded.
4. Table of ROI by project. Jane prefers to compare percentages rather than absolute numbers. For this
reason, she wants you to divide each of the project NPVs through by the total capital expenditure
for each project and report the ROI percentage.
When you have completed the deterministic decision model, Jane wants you to use this as the basis for
developing a spreadsheet-based stochastic decision model in the other worksheet.
In this Stochastic model worksheet, she wants you to apply triangular distributions to each capital
expenditure and to each NPV.
Jane wants you to treat all of the capital expenditures in the page 2 table as the most likely values. Jane then
wants you to set the minimum and maximum values at 15% below and 30% above the most likely values, to
counter the common bias of under-estimating costs.
She also wants you to treat all of NPVs in the page 2 table as the most likely values. She then wants the
minimum and maximum values set at 20% below and 15% above the most likely values, to counter the
common bias of over-estimating the NPV.
Once you have completed the development of your Stochastic model, Jane wants you to do some
preliminary analysis for her.
She wants you to consider three sets of projects that satisfy the four budget constraints and look promising
in terms of total NPV. Her one stipulation is that each set must include at least project from each division.
She wants you to perform a comparative analysis of the three sets and write up your findings in a report. In
particular she wants you to provide a clear analysis of the risks faced with each the three sets of projects.
MIS275 – Decision Analytics Assignment 2 – Trimester 2, 2020 Page 4
Your submission will be assessed across these six sections for a total unit mark of 30%:
Section 1: Model description, conceptual model, and assumptions (File: MS Word; 5 marks)
? Provide a brief overview of the model
? Include a conceptual model
? Note any relevant assumptions.
Section 2: Spreadsheet-based deterministic decision model (Files: MS Word & Excel; 5 marks)
Complete all parts of the spreadsheet-based deterministic decision model. All cells displaying calculated
values, summary values and output values must contain the underlying Excel formulas.
Section 3: Scenario analysis (Files: MS Word & Excel; 5 marks)
This section relates to Topic 7. Use Excel’s scenario analysis to investigate the impact that best and worst
scenarios, for both capital expenditure and NPV, have on the summary values and output values. The choice
of best and worst scenarios is yours.
Section 4: Spreadsheet-based stochastic decision model including justification for the choice of
distribution (Files: MS Word & Excel; 5 marks)
This section relates to Topic 8. Complete all parts of the spreadsheet-based stochastic decision model.
Justify the choice of probability distribution.
Section 5: Simulated output distribution and a risk analysis (Files: MS Word & Excel; 5 marks)
This section relates to Topic 9. This requires you to undertake a risk analysis based on simulation modelling,
in order to quantify the risks associated with problem.
Section 6: Report (File: MS Word; 5 marks)
The report should be a standalone document. It should include:
1. A brief description of the stochastic model (maximum 100 words)
2. The conceptual model and any assumptions behind the model.
3. The deterministic decision model copied from the spreadsheet.
4. The best- and worst-case scenarios chosen, and a discussion of the consequences.
5. The stochastic decision model copied from the spreadsheet.
6. Justification for the choice of probability distribution.
7. Risk analysis report based on the simulation modelling.
MIS275 - Decision Analytics Assignment 2 – Trimester 2, 2020 Page 5
Rubric for Assignment 2
Performance Levels
Criteria
YET TO ACHIEVE MINIMUM STANDARD MEETS STANDARD EXCEEDS STANDARD
Poor (0‐49) Satisfactory (50‐59) Good (60‐69) Very good (70‐79) Excellent (80‐100) Format
Model description,
conceptual model,
and assumptions
ULO1/GLO1
Total: 5 marks
0
Conceptual model
is inappropriate or
not clearly
outlined
1.5
A vague conceptual
model is given, with
several modelling errors
2.5
An appropriate conceptual
model is given. Relationships
are mostly correctly specified
3
A clear conceptual model is
given. Relationships are mostly
correctly specified
3.5
A very clear conceptual model
is given. All components are
modelled correctly in a clear
way
5
A very clear conceptual model is given. All
components are modelled correctly in a
clear and innovative fashion
MS Word
report
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Decision models
ULO1,3/GLO1,4
Total: 5 marks
0
Decision models
remain incomplete
with some formulas
or values missing
1.5
Decision models are
complete. All stochastic
inputs can only display
averages
2.5
Decision models are complete.
Some stochastic inputs can
only display fixed values
3
Decision models are complete.
All stochastic inputs display
appropriate random values.
There are errors in fixed inputs
or calculated values
3.5
Decision models are complete.
All stochastic inputs display
appropriate random values.
Only errors are in some
formulas for outputs
5
Decision models are complete. All
stochastic inputs display appropriate
random values. All formulas in the models
are correct
MS Word
report
&
Excel
spreadsheet
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Scenario analysis
ULO1,2,3/GLO1,3,4
Total: 5 marks
0
Scenario analysis
report is not
included or is
inappropriate
1.5
Some possible scenario
analyses are presented,
but not clearly
2.5
Most of the important
scenarios are considered for
the analysis
3
Most of the important
scenarios are considered for
the analysis and elaboration on
them is presented clearly
3.5
All of the main scenarios are
considered, justified in a clear
way, and presented in a
compelling fashion
5
All scenarios are considered, fully justified
in a clear way, and presented in a
compelling fashion
MS Word
report
&
Excel
spreadsheet
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Stochastic decision
model including
choice of distribution
ULO1,2,3/GLO1,3,4
Total: 5 marks
0
Stochastic modelling
not included or
inappropriate
1.5
Stochastic modelling is
poorly implemented and
analysed
2.5
Some effective stochastic
modelling is used with poor
choice of distribution
3
Some effective stochastic
modelling is used with some
elaboration on distribution
3.5
Stochastic modelling is used
effectively. Choice of
distribution is justified
5
Stochastic modelling is used effectively.
Choice of distribution is fully justified
MS Word
report
&
Excel
spreadsheet
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Simulated output
distribution and risk
analysis report
ULO1,2,3/GLO1,3,4
Total: 5 marks
0
Simulated output
and risk analysis are
not included or are
inappropriate
1.5
Unclear simulation
outputs are presented.
Unclear analysis of the
effect of input risks
2.5
Some analysis of simulation
output is presented. It
considers some relevant
stochastic inputs, with some
discussion of their effect on
output
3
Reasonable analysis of
simulation outputs is
presented. It considers some
of the main stochastic inputs,
with some discussion of their
effect on output
3.5
Clear and reasonable analysis
of simulation output. A
comprehensive consideration
of the main stochastic inputs,
with some discussion of their
effect on output
5
Clear and comprehensive analysis of
simulation output is provided with
comprehensive consideration of the main
stochastic inputs, and discussion of their
effect on output
MS Word
report
&
Excel
spreadsheet
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Report
ULO3/GLO4
Total: 5 marks
0
Report is not
included or is
inappropriate
1.5
Report is not a
standalone document,
requiring review of
spreadsheet to
understand results on
which report is based.
Displays a general lack
of clarity or logic in
interpretation or
analysis of results
2.5
Report is largely a standalone
document, though may require
a review of the spreadsheet to
help understand some points.
Some areas lack clarity or logic
in interpretation or analysis of
results, or there are a few
errors or omissions
3
Report is a completely
standalone document.
A clear and logical report is
provided across all areas, where
results of analysis have been
satisfactorily examined and
accurately interpreted.
Some areas of the report display
a lack of depth in understanding
3.5
Report is a completely
standalone document.
A clear and logical report is
provided across all areas, where
results of analysis have been
examined, interpreted and
described accurately, precisely
and concisely. Report displays a
understanding across all areas
5
Report is a completely standalone
document.
A clear and logical report is provided
across all areas, where results of analysis
have been examined, interpreted and
described accurately, precisely and
concisely. Report displays understanding
across all areas.
Report concludes with some key insights
MS Word
report
0 - 1.4 Marks 1.5 - 2.4 Marks 2.5 – 2.9 Marks 3.0 – 3.4 Marks 3.5 – 3.9 Marks 4 – 5 Marks
Total marks 30 (30%)

版权所有:留学生编程辅导网 2021,All Rights Reserved 联系方式:QQ:99515681 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。