Evaluation report

RMIT Classification: Trusted
School of Accounting, Information Systems and Supply Chain

OMGT2287 Supply Chain Modelling and Design
Assessment 2: Evaluation report

Assessment type: Evaluation report [Individual] Word limit: No word limit
Due Date: Sunday Week 5, 23:59 (Melbourne time)
Weighting: 30%

Overview
In this assessment, you are required to formulate a mathematical model representing the problem, to
create and design a spreadsheet solution, and to write a report with sensible recommendations based on
the findings. Your recommendations should be aimed at a line manager of the organisation. The purpose
of this assessment is to develop your capabilities in solving problems and writing reports.
In addition to reading this assessment brief, please read through the case study presented to you, which
is available on the assessment page under Assessment Task 2.
Course learning outcomes
This assessment is relevant to the following course learning outcomes:

CLO1 Analyse and apply the theories and practices of logistics systems in logistics
management
CLO2 Formulate and propose supply chain and logistics systems solutions to improve the
management of logistics and supply management
CLO3 Implement mathematical models to solve problems in logistics in contemporary
business environment
CLO4 Critically reflect your proposed supply chain and logistics solutions in communicating
with relevant stakeholders

Page 2 of 7
RMIT Classification: Trusted
Assessment criteria
You will be marked on the following criteria:
Problem Formulation (Word) (9 pts)
• Explanation of how the problem was formulated
• Clearly defines decision variables and explains objective functions and their
constraints correctly and clearly.
ProblemSolving (Word & Excel) (9 pts)
• Demonstration of how the model was implemented and how the solution was
generated in a step-by-step manner in the report
• Clear evidence of using an Excel spreadsheet to solve the model
Discussion (Word) (4.5 pts)
• Discuss the solution to the integer linear programming model thoroughly by using
concepts that were taught in the learning content
Recommendation (Word) (4.5 pts)
• Recommendations provided are grounded in the discussion and analysis presented
within the report
• The recommendation links to improvements in the current state of the situation and
explains how in relation to the context feasibility
Presentation (Word & Excel) (3 pts)
• All report components such as executive summary, table of content, lists of figures/
tables, and references are present
• General formatting of your report and Excel spreadsheet
Assessment Details
This report requires you to solve a problem in a case study using integer linear programming techniques
that you have learned in the course. You are expected to demonstrate your capabilities in
understanding the nature of the problem, formulating a mathematical model,
and creating and designing
a spreadsheet solution using Excel and Excel Solver.
To complete this assessment, you will be able to find the details of the case study on a separate
document named Assessment 2 Case Study. You are encouraged to use the concepts discussed in
Week 3 – Integer linear programming to complete this assessment successfully.

Page 3 of 7
RMIT Classification: Trusted
Guidelines: Report Structure
Please refer below for guidance on how you should structure your report.
1. Cover page
a. Include the report’s title, your name and student ID, the class and facilitator’s name
2. Problem Formulation (Please ensure that all mathematical symbols are correct and consistent).
a.
Define decision variables with a measurement unit (e.g., pallets, kg, or km).
b.
Provide an objective function and constraints and clearly show how you formulate them with
an explanation of what each equation means
.
c.
Ensure that decision variables and each equation are linked back to the data.
3.
Problem-Solving (i.e., step-by-step process of how you find the solution)
a. Explain how you implement the model in the Excel spreadsheet.
b. For example, explain how you implement each equation in the model using what functions
in Excel (e.g., SUMPRODUCT) and where you place it on the spreadsheet (e.g., at Cell
B2).
c. If constraints are the same kind and implemented in the same way, you just need to explain
the first one and summarise the rest.
d. Explain how you set up Solver in Excel.
e. Don’t forget to submit the Excel spreadsheet together with the Word report.
4. Discussion
a. Discuss the optimal solution based on the results you find.
b. Compare and highlight the differences and areas of improvement between your findings
and the current operations in the case.
c. If you conduct sensitivity analysis, the results should be presented here.
5. Recommendations
a. List and discuss what action should be taken based on the discussion.
b. For example, the results may suggest that the optimal solution for the production problem is
to make 3 units of X and 4 units of Y. In addition, sensitivity analysis indicates that an
increase of each Resource A can increases the profit by $5, up to the maximum of 100
units of Resource A. Your first recommendation can be to produce 3 units of X and 4 units
of Y, and the second recommendation is to procure additional 100 units of Resource A.
6. Presentation
a. Discussion and explanation are succinct.
Page 4 of 7
RMIT Classification: Trusted
b. There is a link between each section. And when the report is read, the reader should not
feel jumpy (i.e., some important information is omitted).
c. Cross-referencing and citations are correct (if any).
d. All headings and sections are in place.
e. Images or figures are clear.
f. The writing is readable. You may use Flesch–Kincaid readability tests to evaluate your
report.
g. Font Size: 11pt or 12pt
h. Font Style: Calibri or Times New Roman
i. Document Margins: 2.5cm for top, bottom, left and right
j. Spacing: Single or 1.5 spacing
Length
To simulate a real-world experience, there is no word limit for this assessment task. You are expected to
provide a quality response on the assessment task that addresses the case study question(s). You are
also expected to follow the structure suggested above and ensure that your submission is aligned with the
assessment rubric.
Submission format
For this assessment, you need to submit the following files in Canvas as a file upload. Both files should be
submitted together.
You must submit:
1. An evaluation report in a single Word document (.docx)
The Word document is to explain your mathematical model, to report and
discuss your answers, draw a conclusion and provide recommendations for
decision makers based on the solution.
2. An Excel file (.xlsx)
• An Excel file to demonstrate how you use Solver to identify solution(s).
• You must ensure that the file is in a workable condition before submission.

Page 5 of 7
RMIT Classification: Trusted
Referencing guidelines
Use RMIT Harvard referencing style for this assessment.
You must acknowledge all the courses of information you have used in your assessments.
Refer to the
RMIT Easy Cite referencing tool to see examples and tips on how to reference in the
appropriated style. You can also refer to the library referencing page for more tools such as
EndNote, referencing tutorials and referencing guides for printing.
Academic integrity and plagiarism
Academic integrity is about honest presentation of your academic work. It means acknowledging
the work of others while developing your own insights, knowledge and ideas.
You should take extreme care that you have:
Acknowledged words, data, diagrams, models, frameworks and/or ideas of others you have
quoted (i.e. directly copied), summarised, paraphrased, discussed or mentioned in your
assessment through the appropriate referencing methods
Provided a reference list of the publication details so your reader can locate the source if
necessary. This includes material taken from Internet sites
If you do not acknowledge the sources of your material, you may be accused of plagiarism
because you have passed off the work and ideas of another person without appropriate
referencing, as if they were your own.
RMIT University treats plagiarism as a very serious offence constituting misconduct.
Plagiarism covers a variety of inappropriate behaviours, including:
Failure to properly document a source
Copyright material from the internet or databases
Collusion between students
For further information on our policies and procedures, please refer to the University website.
Assessment declaration
When you submit work electronically, you agree to the assessment declaration.
Page 6 of 7
RMIT Classification: Trusted
Assessment 2 Criteria

Criteria Ratings Pts
Excellent Good Fair Poor
Problem
Formulation
(Word)
The report shows how the
problem was formulated,
defines decision variables, and
explains objective functions and
their constraints correctly and
The report shows how the
problem was formulated,
defines decision variables, and
explains objective functions
and their constraints correctly,
The report inadequately shows
how the problem was
formulated, defines decision
variables, and explains objective
functions and their constraints
correctly.
clearly. but there are some unclear
areas.
The report does not, or hardly, show how
the problem was formulated, define
decision variables, and explain objective
functions and their constraints correctly.
9.00 to > 6.74 pts 6.74 to > 4.49 pts 4.49 to > 2.24 pts 2.24 to > 0 9
ProblemSolving
(Word and Excel)
The report explains how the
model was implemented and
how the solution was generated
in a step-by-step manner in the
Excel sheet well. The model
implemented in the Excel
spreadsheet and specified in
Solver was correct. The right
answer was obtained.
The report explains how the
model was implemented and how
the solution was generated in a
step-by-step manner in the Excel
sheet well, but there are some
unclear areas. The model
implemented in the Excel
spreadsheet and specified in
Solver was mostly correct.
The report inadequately explains
how the model was
implemented and how the
solution was generated in a step
by-step manner in the Excel
sheet. The model implemented
in the Excel spreadsheet and
specified in Solver was partly
correct.
The report does not, or hardly, explain how
the model was implemented and how the
solution was generated in a step-by-step
manner in the Excel sheet. The model
implemented in the Excel spreadsheet and
specified in Solver was mostly incorrect.
9.00 to > 6.74 pts 6.74 to > 4.49 pts 4.49 to > 2.24 pts 2.24 to > 0 9

Page 7 of 7
RMIT Classification: Trusted

Discussion
(Word)
The report discusses the solution
well.
The report discusses the solution,
but there are some unclear areas.
The report inadequately
discusses the solution.
The report does not, or hardly, discuss the
solution.
4.5 to > 3.37 pts 3.37 to > 2.24 pts 2.24 to > 1.12 pts 1.12 to > 0 4.5
Recommendation
(Word)
The report discusses the sensible
recommendations for the
decision maker based on the
findings well.
The report discusses the sensible
recommendations for the decision
maker based on the findings well,
but there are some unclear areas.
The report inadequately
discusses the sensible
recommendations for the
decision maker based on the
findings.
The report does not, or hardly, discuss the
sensible recommendations for the decision
maker based on the findings.
4.5 to > 3.37 pts 3.37 to > 2.24 pts 2.24 to > 1.12 pts 1.12 to > 0 4.5
Presentation
(Word and Excel)
The report and spreadsheet are
very easy to follow. Presentation
is very clear. All report
components such as executive
summary, table of contents,
lists of figures/tables, and
references are present.
The report and spreadsheet are
easy to follow. Presentation is
clear. Some report components
such as executive summary,
table of contents, lists of figures/
tables, and references are
absent.
The report and spreadsheet are
difficult to follow. Presentation is
unclear and/or confusing. Many
report components such as
executive summary, table of
contents, lists of figures/tables,
and references are absent.
The report and spreadsheet are very
difficult to follow. Presentation is very
unclear and/or confusing. Report
components such as executive summary,
table of contents, lists of figures/tables,
and references are mostly absent.
3 to > 2.24 pts 2.24 to > 1.49 pts 1.49 to > 0.74 pts 0.74 to > 0 pts 3
Total: 30 pts