1 | P a g e

FIT3158 Business Decision Modelling
Semester 2, 2021
Assignment Two


Due Date: Monday 18th October 2021 11pm
Value: 30% of Final Assessment
Mode of submission: Online on Moodle
Type of Assignment: Group Assignment


This group assignment requires the collaborative effort of three students per group. Students must
form the group (within the same tutorial) and elect a group leader to coordinate this assignment. He
or she must inform the tutor during week 3 tutorial of the group members’ names. Once confirmed,
no change of group member is allowed without prior approval from the FIT3158 lecturer.

About 15 minutes will be allocated at the end of each week’s tutorial for group members to come
together to discuss and work on the assignment. You may also use this time to consult your tutor if
you have any issues with your assignment. Every student in the group is required to actively
participate and would be used as a basis for marks adjustment for the final score (if necessary) of the
assignment.

This assignment is in 3 parts:
1. Case 1: Linear Programming (to be released in Week 3)
2. Case 2: ILP and Network Models (to be released in Week 5) and
3. Case 3: Inventory Modelling (to be released in Week 8)


Learning Objective (Learning Outcomes: 1, 2, 3 & 4)

The aim of this assignment is to provide students with an opportunity to develop their problem solving
as well as modelling skills. In so doing, the following objectives are sought:
 The ability to critically analyse business problems;
 The ability to design, implement and analyse mathematical optimisation and spreadsheet-based
models;
 The ability to conduct sensitivity analysis and to interpret the results of mathematical decision
models to aid business decision and
 To present your findings and recommendations in a coherent report.





2 | P a g e

Delivery structure and submission instructions:

1. Your delivery should include 3 Excel files:
1.1. An Excel file for Case 1 of the assignment comprising the following components:
1.1.1. Documentation
1.1.2. Case 1 Model
1.1.3. Case 1 Sensitivity/Answer Report
1.1.4. Case 1 Analysis and Report
1.2. An Excel file for Case 2 of the assignment comprising the following worksheets:
1.2.1. Documentation
1.2.2. Case 2 Model
1.2.3. Case 2 Analysis and Report
1.3. An Excel file for Case 3 of the assignment comprising the following worksheets:
1.3.1. Documentation
1.3.2. Case 3 Model
1.3.3. Case 3 Analysis and Report
2. The ‘Documentation’ sheet should include the following information:
- The title page
- Team members contribution (tasks performed and contribution %).
3. You are to upload your submission on the FIT3158 Moodle site under the “FIT3158
Assignment 2” submission link.
4. You should name your Excel file as: Assignment 2_Case #.xlsx (or xlsm) where
is the number assigned to your team by your tutor and # is the Case number.
5. Due: Monday 18th October 2021 11pm

Assessment criteria:
 Correct formulation
 Good spreadsheet design. (Refer to Lecture 2 Slide 14 – 16)
 Correct and reliable results.
 Correct response to the questions asked.
 Good analysis and discussion/recommendations showing understanding.
 Well-presented and coherent report.
(The marking criteria will be provided for each case.)

欢迎咨询51作业君