What am I required to do in this assignment?
Requirements: Everyone will be given the same case study but with different data, which
you will write a management report on. The report will be based on your Excel analysis. The
report has to be understandable as a standalone piece of work without referring to the Excel
file. You need to provide tables and figures from the Excel analysis to support your report.
The deadline for group assignment is 12 noon Friday 3th May 2024.
Both the report and the Excel file need to be submitted to Blackboard. Graphs should be
carefully labelled and explained. The Excel file must demonstrate all of the obtained
answers.
Word limit of the report is 1500 words. The data for each individual will be posted in a
separate Excel spreadsheet.
If you do not submit the Excel file, you will automatically lose 50% mark of all tasks that
require Excel. Calculation and graph tasks that are not visible in Excel will also lose 50% mark
automatically.
The Russo Manufacturing company
The Russo Manufacturing Company must decide whether to manufacture a component part
at its Milan plant or purchase the component part from a supplier. The resulting profit is
dependent upon the demand for the product. If the demand for the finished product is low,
Russo will incur a loss of [i.] if it decided to manufacture the component part. On the other
hand, if Russo purchases the component part, it will not incur any production cost and the
profit is estimated to be [ii.] when the demand of the finished product is low. In a better
scenario when demand for the finished product is high, Russo will earn [iii.] if it manufactures
the component part in house, or [iv.] if it purchases the part. Finally, when demand for the
finished product is at medium level, Russo will earn [v.] profit if it manufactures the
component part, or [vi.] if the part is purchased from a supplier.
3
Originally the management estimate the probability of weak demand to be [vii.] and of strong
demand to be [viii.]. However, the management is concerned about the accuracy of this
estimation and is contemplating of conducting extra market research to determine the
likelihood of different states of demand. The cost of the research is [ix.] and the research can
indicate if market condition is favourable or unfavourable. The research is fairly reliable,
meaning it is more likely to obtain a favourable result if the demand for the finished product
is truly high. On the other hand, the report will be less likely to generate a favourable result if
the demand for the finished product is truly low. The probabilities of obtaining a favourable
report given a certain market condition are:
P (F | low demand) = [x.]
P (F | medium demand) [xi.]
P (F | high demand) = [xii.]
Task:
Perform an analysis of the problem facing Allied Insurance and prepare a report that
summarizes your findings and recommendations. Be sure to address the following issues:
- The payoff table of Russo Manufacturing, ignoring all the probabilities.
(5 marks) - Recommendations regarding which decision the management should take if they
ignore the probabilities and decide to apply the following decision criteria:
a. Optimistic Approach
(5 marks)
b. Conservative Approach
(5 marks)
c. Minimax Regret Approach
(5 marks) - Computation of the posterior probabilities of weak demand, medium demand and
strong demand given the market research is conducted. Briefly explain the meaning
of these probabilities.
(5 marks) - A decision tree illustrating the decisions and events that Russo is facing. All the
payoffs, probabilities and decision at each step need to be labelled carefully on the
tree.
(25 marks) - A recommendation whether the market research should be undertaken. Explain
clearly the reasons for your recommendation.
(10 marks) - A decision strategy that Russo should follow if they take the recommended action in
5.
(10 marks) - A sensitivity analysis to illustrate how different decisions change if the prior probability
of [xiii.] change by 0.1 at a time.
(20 marks)
Presentation (10 marks)
The report must be written in a clear manner and including the required items. There is no
need to restate the questions in your report. Your report must have the following structure:
I. Executive summary
4
Give an overview of the problem, the solutions and the recommendation
II. Introduction
Introduce the case study and the objectives of the report
III. Main body
This section addresses all the questions associated with the case study.
IV. Conclusion
Conclude the case study and present your recommendations to the board of directors based
on the analysis.
Is there a size limit?
1500 words
What do I need to do to pass?
Threshold criteria i.e. achievement of the learning outcome at the pass/fail boundary
Submit the Excel file
Demonstrate basic understanding of decision analysis
Able to identify and translate real life case study to basic decision tree
Able to compute basic calculation using Excel
Address the questions asked.
How do I produce high quality work that merits a 70% or above grade?
Submit the Excel file
5
Demonstrate deep understanding of decision analysis.
Able to identify and translate complex decisions and events to a decision tree.
Ability to discern the meaning of different probabilities and their roles for the decision tree.
Ability to employ different Excel tools to achieve the answer.
Ability to interpret the mathematical answers in real life context.
Answer the questions clearly and carefully
Report is presented carefully with all the necessary figures supporting the answers.
How does assignment relate to what we are doing in the scheduled sessions?
The skills necessary to complete the assignment are practiced and discussed in the
scheduled webinar sessions.
How will I receive formative feedback for this assignment?
Formative deadline: 16th April 2024
6
Marks and Feedback
How will my assignment be marked?
Your assignment will be marked according to the threshold expectations above and the marking
criteria below. You can use them to evaluate your own work and estimate your grade before you
submit.
Marking Criteria Table
Issue 80% -100% 70%-79% Grade 60%-69% 50%-59% 40-49% 0-39%
Relevance to
assignment
brief
Assignment’s aims and
themes are integral to the
assignment.
Clear focus on the
themes of the
assignment.
Mainly focused on
the themes of the
assignment.
Some of the writing
is focused on the
themes of the
assignment.
Not relevant attempt to
address the themes of
the assignment.
Makes no attempt to
address the themes of the
assignment.
Extent of evaluation Evaluation within
assignment rigorous and
appropriate.
Good clear evidence
of evaluation carried
out within assignment.
Evaluation
reasonably well
carried out
Some attempt at
evaluation within
assignment.
Not relevant attempt at
evaluation within
assignment
No attempt at
evaluation within
assignment
Quality
of
reasoning
Analytical and clear
conclusions well- grounded
in theory and literature,
showing development of new
concepts.
Good development as
shown in summary of
arguments based on
theory/literature and
beginnings of synthesis.
Evidence of findings
and conclusions
grounded in
theory/literature.
Limited evidence of
findings and
conclusions supported
by the literature and
theory.
Lack of
substantiated/valid
conclusion, based on
anecdotes and
generalisations only.
Unsubstantiated/invalid
conclusion, based on
anecdotes and
generalisations only.
Skill at
facilitating
discussion
Excellent enabling
pacing and
summarising of
discussion.
Clear evidence of
ability to stimulate,
facilitate and
summarise
discussion.
Some ability to
stimulate and
facilitate discussion
or be directive.
Some ability to
facilitate discussion
but tendency to miss
opportunities.
Limited ability to
stimulate/
facilitate discussion.
Inability to stimulate/
facilitate discussion.
Clarity and
quality of written
expression
Clarity of expression
excellent. Consistently
accurate use of grammar and
spelling
professional/academic
writing style.
Thoughts and ideas
clearly expressed.
Grammar and
spelling accurate
with fluent fluent.
Language mainly
fluent. Grammar and
spelling mainly
accurate and language
fluent
Meaning apparent
but…. language not
always fluent,
grammar and
spelling still poor.
Purpose and meaning
of assignment unclear.
Language, grammar and
spelling weak.
Purpose and meaning
of assignment unclear.
Language, grammar and
spelling poor.
Understanding of
subject
Work shows a well-coordinated, grounded and
reasoned understanding of
topic and its relevance to
practice
Consistent
understanding
demonstrated in a
logical, coherent and
lucid manner.
Demonstrates
understanding in a
style which is
logical, coherent and
flowing.
Attempts a logical
and coherent
understanding of the
subject area.
Marginal fail to
demonstrate
understanding of the
subject/topic area.
Fails to demonstrate
understanding of the
subject/topic area.