讲解FIT5097语言编程、辅导Analysis设计程序、讲解Python，Java编程
- 首页 >> Matlab编程 Monash University
Faculty of Information Technology
FIT5097 Business Intelligence Modelling
2
nd Semester 2020
Assignment: Linear Programming, Sensitivity Analysis,
Transshipment/Network Modelling and Integer Linear Programming - and
Inventory Management - using Microsoft Excel Solver
This assignment is worth 30% of your final mark (subject to the hurdles described in the
FIT5097 Moodle preview [or Unit Guide] and links therein). Among other things (see
below), note the need to hit the `Submit’ button (i.e., don’t just leave your work in
unsubmitted `draft’ mode) and also note the requirement of an interview.
Due Date: Wednesday 14
th October 2020, 11:45pm in time zone of Melbourne, Australia
Method of submission: Your submission should consist of 2 files:
1. A Microsoft Excel spreadsheet named as:
FamilyName-StudentId-2ndSem2020FIT5097.xlsx
2. A text-based .pdf file named as: FamilyName-StudentId-2ndSem2020FIT5097.pdf
Both the files must be uploaded on the FIT5097 Moodle site by the due date and time. The
text-based .pdf file will undergo a similarity check by Turnitin at the time you submit to
Moodle. Please read submission instructions on the last page carefully re use of Moodle.
Please read all instructions - including the notes below - carefully.
Total available marks = 100 marks.
(60 + 32 + 10 = 102 marks are available. Any mark over 100 will be rounded down to 100.)
Note 1: Please recall the Academic Integrity exercises from week 1 and the start of semester. In
submitting this assignment, you acknowledge both that you are familiar with the relevant policies, rules
and regulations regarding Academic Integrity and also that you are familiar with the consequences of
being deemed to be in contravention of these policies. Students are expected to do their own work and
not to share their work. Among other things, students are reminded not to post even part of a proposed
partial solution to a Moodle forum, Ed Discussions or other location. Students are reminded of the
potentially serious consequences of being found guilty of an academic integrity violation. Put plain
and simply, please take great care in this regard.
Note 2: It is your responsibility to be familiar with the special consideration policies and special
consideration process - and also with other policies (e.g., academic integrity, etc).
Note 3: You will be required to be prepared to (present and) be interviewed about the work during
lab/tute/studio time - to be determined by your lecturer and tutor, currently scheduled for week 10, but
possibly to be scheduled for week 11. (Stay tuned for confirmation of the week of your compulsory
Assignment interview.) This is a compulsory part of your assessment – only to be re-scheduled if you
have an approved application for special consideration. Students should be familiar with the special
consideration policies and the process for applying. Students who do not attend the scheduled
assignment interview without valid approved grounds for special consideration will possibly be given a
mark of 0 for the assignment - i.e., we reserve the right to give any such student a mark of 0 for their
assignment in such cases. As previously advised, students should be familiar with the special
consideration policies and the process for applying.
Note 4: As a general rule, don’t just give a number or an answer like `Yes’ or `No’ without at least
some clear and sufficient explanation - or, otherwise, you risk being awarded 0 marks for the relevant
exercise. Evidence of working is expected to be shown. Make it easy for the person marking your
work to follow your reasoning. Evidence of working includes - but is not limited to - showing clearly
relevant spreadsheet tabs for every question and sub-question requiring calculations. Please
1
understand that a failure to require a spreadsheet tab when one is relevant for a question or
sub-question could result in very few - or potentially even zero - marks for the relevant question or
sub-question. Your .pdf should typically cross-reference the corresponding answer in your
spreadsheet. For each sub-question and exercise, provide a clearly labelled spreadsheet tab with clear
content and appropriate use of colours, accompanied with clearly cross-referenced clear .pdf
explanation. Put another way, make sure that everything in your assignment is there, and make it easy
for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab, there is
the possibility that any such exercise will be awarded 0 marks.
Note 5: As a general rule, if there is an elegant way of answering a question - e.g., without
unnecessarily re-running the Solver - then try to do it that way. (Recall, e.g., sensitivity report and
some notions from Week 4.) More generally, more elegant solutions are preferable - and will at least
sometimes be given more marks or perhaps many more marks. Among other things, if a problem is a
linear programming (LP) problem, then it would be more elegant to solve it using a linear simplex
model (than, e.g., a non-linear model) where possible. In similar vein, a linking constraint (where
appropriate) will be far preferable to a seemingly equivalent use of the IF() function.
Note 6: All of your submitted work should be in machine readable form (in spreadsheet form or typed
document), and none of your submitted work should be hand-written.
Note 7: If you wish for your work to be marked and not to accrue (possibly considerable and
substantial) late penalties, then make sure to upload the correct files and (not to leave your files as
`Draft’ but) also to hit Submit to make sure that your work is submitted.
Note 8: The notation 1E-12 corresponds to 1 x 10
-12
, or 0.000000000001. If you see a figure of
approximately this magnitude or comparable magnitude, then consider whether or not it might be a
small rounding error for something else. The notation 1E+30 corresponds to 1 x 10
30
, or
1,000,000,000,000,000,000,000,000,000,000, but is often used in MicroSoft Excel to denote infinity.
Note 9: For all solutions involving integer constraints, first see whether you can get the optimal
integer solution - and, that failing, see whether you can get an integer solution within a relatively small
percentage (e.g., 1% or less, if possible) of the optimal relaxed solution (where the relaxed solution
does not have the integer constraints). (The reason for the last sentence is an acknowledgment that
obtaining the optimal integer solution typically requires much more run-time than obtaining the optimal
relaxed solution.) At the very least, make it clear to the person marking your work exactly what you’re
doing, and why.
Question 1 – Linear Programming and variants [6 + 6 + 4 + 3 + 3 + 3 + 3 + 4 + 2 + 2 +
3 + 3 + 3 + 3 + 3 + 3 + 3 + 3 = 60 marks]
We use resources to make products. Consider 6 such resources and 5 such products. The various
resources that we use might include (e.g.) linen, elastic, plastic, foam, etc. The various products that we
make might include (e.g.) soap, sanitiser, washable masks, disposable masks, filters, shields, other
personal protection equipment (PPE), etc. (Alternatively, the products might possibly be various
graphical processing units - or GPUs - and the various resources might possiblybe Solder, Copper wire,
Plastic, Aluminium, Bearings, Die size.)
We show below the profit of each product, the number of each resource required to make each product,
and the total availability of each resource.
Unless we are explicitly told that a variable is integer-valued (or otherwise discrete-valued or binary,
etc), it will probably be safer not to make such an assumption and rather instead allow the variable to
be continuous-valued. (Note that sub-questions such as part 1m will occur later.) If unsure, clearly
state and justify any assumptions. Please state such continuous values to at least three decimal places.
2
Product 1 Product 2 Product 3 Product 4 Product 5
Profit of Product $510 $300 $510 $270 $810
Resource Availability
Resource 1 2 10 2 3 6 2487
Resource 2 6 3 6 3 10 3030
Resource 3 2 3 10 6 2 5217
Resource 4 7 6 5 4 3 4000
Resource 5 5 6 3 10 2 4999
Resource 6 10 3 5 3 4 2769
We wish to produce products - given constraints - so as to optimise our objective function.
Bearing in mind the introductory material above, the questions follow below:
1a) Formulate a Linear Programming (an LP) model for this problem. Save your
formulation in the text-based .pdf file
[FamilyName-YourStudentId-2ndSem2020FIT5097.pdf]. (6 marks)
1b) Create a MicroSoft Excel spreadsheet model for this problem. Store the model
in your Excel workbook
[FamilyName-YourStudentId-2ndSem2020FIT5097.xlsx] and name your first
Excel worksheet (spreadsheet tab) for this question something like (e.g.)
‘LotsOfProducts 1b’ (6 marks)
1c) Solve the problem - using Microsoft Excel Solver. Generate the Sensitivity
report for the problem and name your Excel worksheet (spreadsheet tab) (e.g.) ‘Qu
1b Sensitivity Rep’. (4 marks)
Using the Microsoft Excel Solver sensitivity report (as appropriate), provide answers (in the
.pdf file) to the following questions: (You must include explanations with your
answers.)
1d) What is the optimal production plan (X1
, X2
, X3
, X4
, X5
) and the associated profit?
Refer to your answers to any of a), b) and/or c) above as appropriate. (3 marks)
For the remaining parts of this question, explain your answer(s), typically referring to relevant
spreadsheet entry/ies and/or specific relevant parts of spreadsheet reports.
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
3
1e) Which constraints, if any, are binding? Refer to your answers to any of the
above parts as appropriate, and explain your reasoning. (3 marks)
1f) The people running the company are now offered the opportunity of an exchange
of goods.
The offer is for the company to receive 1 of Resource 2, 10 of Resource 4 and 100 of
Resource 5 but for the company to have to relinquish (or surrender, or give away. or pay for
these resources with) 10 of Resource 1, 5 of Resource 3 and 3 of Resource 6.
Should the company accept this offer?
Clearly explain with clear calculations (to at least 3 decimal places) how much money the
company would gain or lose by agreeing to such an exchange, making it clear whether this
would result in a gain or a loss.
Let us return to the original problem above (prior to the company being made an offer) from
part d.
A proposal is put forward to produce a new product called Product 6.
Product 6 would have a profit of $155 and would require the following resources: 2 of
Resource 2, 4 of Resource 4 and 5 of Resource 5.
1g) Would we expect Product 6 to be produced - i.e., if we are to produce products to
optimise our objective function, would we produce any copies of this new product?
If we would expect Product 6 to be produced, then how much less profitable could Product 6
be and still be produced?
If we would not expect Product 6 to be produced, then how much more profitable would
Product 6 need to be in order to be produced?
Let us again return to the original problem above from part d, where the profitability of the
various products was (510, 300, 510, 270, 810).
Various employees at the company have considered making changes which would affect the
profitability of various products.
One change would result in (512, 301, 511, 269, 811).
1h) Explaining your reasoning, when compared to your original answer using
(510, 300, 510, 270, 810), would your optimal amount to be produced of each of Product1, ...,
Product5 change? Explain clearly why or why not. And, if the amounts produced would
change, explain clearly with any necessary or relevant calculations what they would change
to.
1i) A second change, if it really could be carried out in practice, would double
the values to become (1020, 600, 1020, 540, 1620).
Explaining your reasoning, when compared to your original answer using (510, 300, 510, 270,
810), would your optimal amount to be produced of each of Product1, ..., Product5
change? Explain clearly why or why not. And, if the amounts produced would change,
explain clearly with any necessary or relevant calculations what they would change to.
4
1j) A third change, which would probably not be a good idea, would halve the
values to become (255, 150, 255, 135, 405).
Nonetheless, if such a change were to take place then, explaining your reasoning, when
compared to your original answer using (510, 300, 510, 270, 810), would your optimal
amount to be produced of each of Product1, ..., Product5 change? Explain clearly why or
why not. And, if the amounts produced would change, explain clearly with any necessary or
relevant calculations what they would change to.
1k) Returning to the original problem and solution from part d, suppose we now
introduce the requirement that Product1, Product2 and Product 5 must be produced in equal
amounts.
Compared to the original feasible region (from part d), does adding this new requirement
make the feasible region larger, stay the same, smaller, or something else? Clearly explain
your answer.
1l part 1) Continuing from part k with this newly introduced requirement that
Product1, Product2 and Product 5 must be produced in equal amounts, what is the optimal
amount to be produced of each of Product1, Product2, Product3, Product4, Product5?
11 part 2) What is the resultant profit (stated to at least 3 decimal places)?
For both part 1 and part 2 of 1l, (in keeping with note 4,) clearly show all working.
Returning to the original problem from part d, suppose we now introduce the additional
requirement that Product1, Product2, Product 3, Product 4 and Product 5 must be produced in
integer amounts.
1m part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1m part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
1n) Continuing on from part m above, assume the same unit profits as before but
now with fixed start-up costs as given below.
Product Product 1 Product 2 Product 3 Product 4 Product 5
Unit Profit $510 $300 $510 $270 $810
Fixed-cost (Start-up cost) 2000 4000 8000 16000 1000
5
1n part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1n part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Suppose we now impose the additional constraint that, if Product3 is produced,
then there must be a minimum of 225 and a maximum of 325 of Product3 produced.
1o part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1o part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Suppose we now change the additional constraint from part 1o (immediately above) to be
that, if Product3 is produced, then
there must be a minimum of 300 and a maximum of 450 Product 3 produced,
and (also) the amount produced of Product3 must also be a multiple of 50.
1p part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1p part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Now suppose that we introduce the requirement that, if Product 2 is produced, then the
amount of Product 2 produced must be one of 102, 103, 105, 107, 111 and we also introduce
the further additional requirement that, if Product 4 is produced, then the amount produced of
Product4 must be one of 320, 330, 350, 370, 410.
1q part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1q part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
6
Remove these most recent additional constraints and again return to part n above.
Suppose we now add the requirements that
Product1 and Product2 are produced in equal abundance,
Product4 and Product5 are produced in equal abundance,
if Product 3 is produced then neither product 1 nor product 2 is produced,
if Product 3 is produced then at least 10 and at most 100 of Product 5 are produced.
1r part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1r part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
7
Question 2 – Transshipment and networks [2 + 3 + 6 + 4 + 3 + 3 + 3 + 3 + 3 + 2 =
32 marks]
Suppose we have a product (possibly masks, possibly shields, possibly containers of hand
sanitiser) that we wish to move from two locations (let’s call them node 1 and node 2, both
with a supply of 75) to two other locations (let’s call them node 7 and node 8, with demands
of 80 and 70 respectively).
We initially assume the transportation costs along edges in the network to be as follows:
From To Unit Cost ($)
Students are expected and required to address question 2 in terms of linear programming (LP)
and - if required - the closest possible variants.
2a) State the variables, and use these variables to state the objective function that we wish
to optimise. (We assume that the cost is something that we wish to minimise.)
2b) How many variables are there? Informally in terms of the network, being as specific
as you can, what do the variables correspond to?
2c) Solve the problem of the flow along edges giving the minimum cost.
Show the amounts of flow along the edges. State the value of the objective function.
State the number of edges with non-zero flow (and, for ease of reference, call this e2c
).
2d) Assuming that the number of edges with non-zero flow is less than e2c
(equivalently,
less than or equal to e2c
- 1), again solve the problem of the flow along edges giving the
minimum cost.
Show the amounts of flow along the edges. State the value of the objective function.
State the number of edges with non-zero flow.
8
2e) If the problem is to have a solution of finite cost (any possible solution at all) in
which goods get from the source/supply/starting points to the demand/sink destination points,
what is the smallest number of edges that can have non-zero flow for such a solution to
occur?
Hint: One way of doing this is to introduce a very large penalty for each edge with non-zero
flow.
In that case (if we require that only this smallest possible number of edges be used), what is
the minimum such cost? (If you followed the hint immediately above, then make sure to
remove the newly introduced large penalty when giving your answer.)
2f) Return to the problem from parts a, b and c above.
Due to maintenance problems along the edge between node 4 and node 5, the unit cost of
using this edge is $40/unit up to 30 units, then $60/unit thereafter.
Show how to solve this problem. In keeping with note 4, solve this problem.
2g) Following on from part f above, due to further maintenance problems along the edge
between node 4 and node 5, the unit cost of using this edge is $40/unit up to 30 units, then
$60/unit up to 55 units (i.e., we could have 30 units @ $40/unit and 25 units @ $60/unit, as
30 + 25 = 55), then $110/unit thereafter.
Show how to solve this problem. In keeping with note 4, solve this problem.
2h) We modify the original problem from parts a, b and c to be a shortest path problem.
The edge costs (from parts a, b and c) should now be assumed to be the length of the edge.
What is the shortest path from node 2 to node 8, and what is the length of the path?
Show how to solve this problem. In keeping with note 4, solve this problem.
2i part 1) Following on from part h, how would you modify your answer if we require that
the path from node 2 to node 8 has to go through node 5?
2i part 2) Following on from part h, how would you modify your answer if we require that
the path from node 2 to node 8 has to go through node 6?
Show how to solve this problem. In keeping with note 4, solve both parts of this problem.
Following on from the themes of part h and part i above, we now ask an open question worth
bonus marks. (The motivation might be that someone has to collect face masks and shields
on their way to a destination, but the order in which they collect them doesn’t matter.)
2j) Suppose we have a start node (call it A), and a destination node (call it D) and two
intermediate nodes (call them B and C respectively) that we have to go through. Suppose also
that we are allowed to go A to B to C to D and we are also allowed to go A to C to B to D,
and that this is not known or specified in advance. How might we set this up as a linear
programming (LP) problem?
We do not require a complete solution for 2j immediately above but wish you to explain in
detail how you would set this up.
9
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
Question 3 – Economic Order Quantity (EOQ) [10 marks]
Suppose that we have an ordering problem with variable costs.
We have a deterministic annual demand of 1000. The cost of placing an order (of any
positive non-zero amount) is $21 for an order. The holding cost of storing items is 25% (or
1/4) per annum of the cost of the goods. (Equivalently, if we wish to change from a year’s
annual demand to the demand over 10 years in a decade, the deterministic demand in a decade
would be 10,000 and the holding cost would be 250% of the cost of the goods. It will be safe
to address the problem in terms of years rather than decades.) As many goods as required can
be held in inventory indefinitely and not be thrown away.
The cost of each good is $4.00 up to 794 units ordered. If we order from 795 up to 1099, we
get a 5% discount and the cost of each good is $3.80. If we order from 1100 up to 1859, we
get an 8% discount and the cost of each good is $3.68. If we order 1860 or more, we get a
15% discount and the cost of each good is $3.40.
What is the optimal order quantity and the optimal total annual cost?
In keeping with note 4, clearly show all working.
A note about your Spreadsheet Model
When building your model, bear in mind the goals and guidelines for good spreadsheet design
as discussed in Lecture 3. Marks are given for good spreadsheet design. Marks will possibly
also be given for originality. Format both your models clearly with comments (and, if
possible, shading), etc. so that it is easy for the user to distinguish which cells are occupied by
decision variables, LHS and RHS constraints, and the objective function. Include a textbox in
each worksheet that describes the formulation in terms of cell references in your model.
Instructions:
You are to upload your submission on the FIT5097 Moodle site and should include the
following:
1. A text-based .pdf document (save as:
FamilyName-StudentId-2ndSem2020FIT5097.pdf) that includes all your answers to
Questions 1 and 2 and 3 (except for the Microsoft Excel Solver part of each
question); and
10
2. A Microsoft Excel workbook (save as:
FamilyName-StudentId-2ndSem2020FIT5097.xlsx) that includes the following
spreadsheets:
i. the spreadsheet model for Question 1;
ii. Sensitivity Rep – the sensitivity report for the Question 1 model (and any other
relevant parts);
iii. other relevant things (including any calculations) for Question 1;
iv. relevant things (including any calculations) for Question 2
v. relevant things (including any calculations) for Question 3
vi. etc.
vii. Anything else you deem sufficiently relevant.
Recall that, at the time you submit (1 and 2) to Moodle, the text-based .pdf will undergo a
similarity check by Turnitin. This is done at the time you upload your assignment to Moodle.
It is also our intention to perform such a check on your .xls/.xlsx file at the same time.
(This ends the submission instructions. Please read them and the notes on pages 1-2
carefully. Also recall that, as a general rule, when answering questions, don’t just give a
number or an answer like `Yes’ or `No’ without at least some clear and sufficient
explanation.)
Late penalties:
Work submitted after the deadline (possibly with a small amount of grace time) will be
subject to late penalties in accordance with the FIT5097 Unit Guide and Faculty and
University policies, and (unless any of the following contravenes the relevant policies)
certainly no less than 5% per calendar day, possibly as much as 10% per calendar day.
If you do not submit matching .pdf and .xls/.xlsx files (e.g., if you submit two files but one is
blank or unreadable, or if you only submit one file), then your work will be deemed late - and
will be subject to the relevant penalties, possibly receiving a mark of 0.
Work submitted 10 or more calendar days after the deadline will be given a mark of 0.
Plagiarism declaration:
You are required to state explicitly that you have done your own work, however the Moodle
assignment submission details permit you to declare this.
For example, if you are presented with an 'Assignment Electronic Plagiarism Statement', then
you are required to complete the 'Assignment Electronic Plagiarism Statement' quiz on the
FIT5097 Moodle site and accept the Student Statement (electronic version of the Assignment
cover sheet). If you do not accept the Student Statement, then your assignment may not be
marked, and you may be given a mark of 0.
Recall instructions above and notes on pages 1 to 2 (including but not only, e.g., Note 4,
Academic Integrity, Special Consideration, make sure to hit the `Submit’ button, the
scheduled interview is compulsory if you want a mark of greater than 0, etc.), and please
follow these carefully.
And a reminder not to post even part of a proposed partial solution to even part of an item
open for assessment to Ed Discussions, a Moodle forum or other public location. You are
reminded that Monash University takes academic integrity very seriously.
*** END FIT5097 Assignment Faculty of I.T., Monash University 2
nd
semester 2020 ***
11
Faculty of Information Technology
FIT5097 Business Intelligence Modelling
2
nd Semester 2020
Assignment: Linear Programming, Sensitivity Analysis,
Transshipment/Network Modelling and Integer Linear Programming - and
Inventory Management - using Microsoft Excel Solver
This assignment is worth 30% of your final mark (subject to the hurdles described in the
FIT5097 Moodle preview [or Unit Guide] and links therein). Among other things (see
below), note the need to hit the `Submit’ button (i.e., don’t just leave your work in
unsubmitted `draft’ mode) and also note the requirement of an interview.
Due Date: Wednesday 14
th October 2020, 11:45pm in time zone of Melbourne, Australia
Method of submission: Your submission should consist of 2 files:
1. A Microsoft Excel spreadsheet named as:
FamilyName-StudentId-2ndSem2020FIT5097.xlsx
2. A text-based .pdf file named as: FamilyName-StudentId-2ndSem2020FIT5097.pdf
Both the files must be uploaded on the FIT5097 Moodle site by the due date and time. The
text-based .pdf file will undergo a similarity check by Turnitin at the time you submit to
Moodle. Please read submission instructions on the last page carefully re use of Moodle.
Please read all instructions - including the notes below - carefully.
Total available marks = 100 marks.
(60 + 32 + 10 = 102 marks are available. Any mark over 100 will be rounded down to 100.)
Note 1: Please recall the Academic Integrity exercises from week 1 and the start of semester. In
submitting this assignment, you acknowledge both that you are familiar with the relevant policies, rules
and regulations regarding Academic Integrity and also that you are familiar with the consequences of
being deemed to be in contravention of these policies. Students are expected to do their own work and
not to share their work. Among other things, students are reminded not to post even part of a proposed
partial solution to a Moodle forum, Ed Discussions or other location. Students are reminded of the
potentially serious consequences of being found guilty of an academic integrity violation. Put plain
and simply, please take great care in this regard.
Note 2: It is your responsibility to be familiar with the special consideration policies and special
consideration process - and also with other policies (e.g., academic integrity, etc).
Note 3: You will be required to be prepared to (present and) be interviewed about the work during
lab/tute/studio time - to be determined by your lecturer and tutor, currently scheduled for week 10, but
possibly to be scheduled for week 11. (Stay tuned for confirmation of the week of your compulsory
Assignment interview.) This is a compulsory part of your assessment – only to be re-scheduled if you
have an approved application for special consideration. Students should be familiar with the special
consideration policies and the process for applying. Students who do not attend the scheduled
assignment interview without valid approved grounds for special consideration will possibly be given a
mark of 0 for the assignment - i.e., we reserve the right to give any such student a mark of 0 for their
assignment in such cases. As previously advised, students should be familiar with the special
consideration policies and the process for applying.
Note 4: As a general rule, don’t just give a number or an answer like `Yes’ or `No’ without at least
some clear and sufficient explanation - or, otherwise, you risk being awarded 0 marks for the relevant
exercise. Evidence of working is expected to be shown. Make it easy for the person marking your
work to follow your reasoning. Evidence of working includes - but is not limited to - showing clearly
relevant spreadsheet tabs for every question and sub-question requiring calculations. Please
1
understand that a failure to require a spreadsheet tab when one is relevant for a question or
sub-question could result in very few - or potentially even zero - marks for the relevant question or
sub-question. Your .pdf should typically cross-reference the corresponding answer in your
spreadsheet. For each sub-question and exercise, provide a clearly labelled spreadsheet tab with clear
content and appropriate use of colours, accompanied with clearly cross-referenced clear .pdf
explanation. Put another way, make sure that everything in your assignment is there, and make it easy
for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab, there is
the possibility that any such exercise will be awarded 0 marks.
Note 5: As a general rule, if there is an elegant way of answering a question - e.g., without
unnecessarily re-running the Solver - then try to do it that way. (Recall, e.g., sensitivity report and
some notions from Week 4.) More generally, more elegant solutions are preferable - and will at least
sometimes be given more marks or perhaps many more marks. Among other things, if a problem is a
linear programming (LP) problem, then it would be more elegant to solve it using a linear simplex
model (than, e.g., a non-linear model) where possible. In similar vein, a linking constraint (where
appropriate) will be far preferable to a seemingly equivalent use of the IF() function.
Note 6: All of your submitted work should be in machine readable form (in spreadsheet form or typed
document), and none of your submitted work should be hand-written.
Note 7: If you wish for your work to be marked and not to accrue (possibly considerable and
substantial) late penalties, then make sure to upload the correct files and (not to leave your files as
`Draft’ but) also to hit Submit to make sure that your work is submitted.
Note 8: The notation 1E-12 corresponds to 1 x 10
-12
, or 0.000000000001. If you see a figure of
approximately this magnitude or comparable magnitude, then consider whether or not it might be a
small rounding error for something else. The notation 1E+30 corresponds to 1 x 10
30
, or
1,000,000,000,000,000,000,000,000,000,000, but is often used in MicroSoft Excel to denote infinity.
Note 9: For all solutions involving integer constraints, first see whether you can get the optimal
integer solution - and, that failing, see whether you can get an integer solution within a relatively small
percentage (e.g., 1% or less, if possible) of the optimal relaxed solution (where the relaxed solution
does not have the integer constraints). (The reason for the last sentence is an acknowledgment that
obtaining the optimal integer solution typically requires much more run-time than obtaining the optimal
relaxed solution.) At the very least, make it clear to the person marking your work exactly what you’re
doing, and why.
Question 1 – Linear Programming and variants [6 + 6 + 4 + 3 + 3 + 3 + 3 + 4 + 2 + 2 +
3 + 3 + 3 + 3 + 3 + 3 + 3 + 3 = 60 marks]
We use resources to make products. Consider 6 such resources and 5 such products. The various
resources that we use might include (e.g.) linen, elastic, plastic, foam, etc. The various products that we
make might include (e.g.) soap, sanitiser, washable masks, disposable masks, filters, shields, other
personal protection equipment (PPE), etc. (Alternatively, the products might possibly be various
graphical processing units - or GPUs - and the various resources might possiblybe Solder, Copper wire,
Plastic, Aluminium, Bearings, Die size.)
We show below the profit of each product, the number of each resource required to make each product,
and the total availability of each resource.
Unless we are explicitly told that a variable is integer-valued (or otherwise discrete-valued or binary,
etc), it will probably be safer not to make such an assumption and rather instead allow the variable to
be continuous-valued. (Note that sub-questions such as part 1m will occur later.) If unsure, clearly
state and justify any assumptions. Please state such continuous values to at least three decimal places.
2
Product 1 Product 2 Product 3 Product 4 Product 5
Profit of Product $510 $300 $510 $270 $810
Resource Availability
Resource 1 2 10 2 3 6 2487
Resource 2 6 3 6 3 10 3030
Resource 3 2 3 10 6 2 5217
Resource 4 7 6 5 4 3 4000
Resource 5 5 6 3 10 2 4999
Resource 6 10 3 5 3 4 2769
We wish to produce products - given constraints - so as to optimise our objective function.
Bearing in mind the introductory material above, the questions follow below:
1a) Formulate a Linear Programming (an LP) model for this problem. Save your
formulation in the text-based .pdf file
[FamilyName-YourStudentId-2ndSem2020FIT5097.pdf]. (6 marks)
1b) Create a MicroSoft Excel spreadsheet model for this problem. Store the model
in your Excel workbook
[FamilyName-YourStudentId-2ndSem2020FIT5097.xlsx] and name your first
Excel worksheet (spreadsheet tab) for this question something like (e.g.)
‘LotsOfProducts 1b’ (6 marks)
1c) Solve the problem - using Microsoft Excel Solver. Generate the Sensitivity
report for the problem and name your Excel worksheet (spreadsheet tab) (e.g.) ‘Qu
1b Sensitivity Rep’. (4 marks)
Using the Microsoft Excel Solver sensitivity report (as appropriate), provide answers (in the
.pdf file) to the following questions: (You must include explanations with your
answers.)
1d) What is the optimal production plan (X1
, X2
, X3
, X4
, X5
) and the associated profit?
Refer to your answers to any of a), b) and/or c) above as appropriate. (3 marks)
For the remaining parts of this question, explain your answer(s), typically referring to relevant
spreadsheet entry/ies and/or specific relevant parts of spreadsheet reports.
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
3
1e) Which constraints, if any, are binding? Refer to your answers to any of the
above parts as appropriate, and explain your reasoning. (3 marks)
1f) The people running the company are now offered the opportunity of an exchange
of goods.
The offer is for the company to receive 1 of Resource 2, 10 of Resource 4 and 100 of
Resource 5 but for the company to have to relinquish (or surrender, or give away. or pay for
these resources with) 10 of Resource 1, 5 of Resource 3 and 3 of Resource 6.
Should the company accept this offer?
Clearly explain with clear calculations (to at least 3 decimal places) how much money the
company would gain or lose by agreeing to such an exchange, making it clear whether this
would result in a gain or a loss.
Let us return to the original problem above (prior to the company being made an offer) from
part d.
A proposal is put forward to produce a new product called Product 6.
Product 6 would have a profit of $155 and would require the following resources: 2 of
Resource 2, 4 of Resource 4 and 5 of Resource 5.
1g) Would we expect Product 6 to be produced - i.e., if we are to produce products to
optimise our objective function, would we produce any copies of this new product?
If we would expect Product 6 to be produced, then how much less profitable could Product 6
be and still be produced?
If we would not expect Product 6 to be produced, then how much more profitable would
Product 6 need to be in order to be produced?
Let us again return to the original problem above from part d, where the profitability of the
various products was (510, 300, 510, 270, 810).
Various employees at the company have considered making changes which would affect the
profitability of various products.
One change would result in (512, 301, 511, 269, 811).
1h) Explaining your reasoning, when compared to your original answer using
(510, 300, 510, 270, 810), would your optimal amount to be produced of each of Product1, ...,
Product5 change? Explain clearly why or why not. And, if the amounts produced would
change, explain clearly with any necessary or relevant calculations what they would change
to.
1i) A second change, if it really could be carried out in practice, would double
the values to become (1020, 600, 1020, 540, 1620).
Explaining your reasoning, when compared to your original answer using (510, 300, 510, 270,
810), would your optimal amount to be produced of each of Product1, ..., Product5
change? Explain clearly why or why not. And, if the amounts produced would change,
explain clearly with any necessary or relevant calculations what they would change to.
4
1j) A third change, which would probably not be a good idea, would halve the
values to become (255, 150, 255, 135, 405).
Nonetheless, if such a change were to take place then, explaining your reasoning, when
compared to your original answer using (510, 300, 510, 270, 810), would your optimal
amount to be produced of each of Product1, ..., Product5 change? Explain clearly why or
why not. And, if the amounts produced would change, explain clearly with any necessary or
relevant calculations what they would change to.
1k) Returning to the original problem and solution from part d, suppose we now
introduce the requirement that Product1, Product2 and Product 5 must be produced in equal
amounts.
Compared to the original feasible region (from part d), does adding this new requirement
make the feasible region larger, stay the same, smaller, or something else? Clearly explain
your answer.
1l part 1) Continuing from part k with this newly introduced requirement that
Product1, Product2 and Product 5 must be produced in equal amounts, what is the optimal
amount to be produced of each of Product1, Product2, Product3, Product4, Product5?
11 part 2) What is the resultant profit (stated to at least 3 decimal places)?
For both part 1 and part 2 of 1l, (in keeping with note 4,) clearly show all working.
Returning to the original problem from part d, suppose we now introduce the additional
requirement that Product1, Product2, Product 3, Product 4 and Product 5 must be produced in
integer amounts.
1m part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1m part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
1n) Continuing on from part m above, assume the same unit profits as before but
now with fixed start-up costs as given below.
Product Product 1 Product 2 Product 3 Product 4 Product 5
Unit Profit $510 $300 $510 $270 $810
Fixed-cost (Start-up cost) 2000 4000 8000 16000 1000
5
1n part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1n part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Suppose we now impose the additional constraint that, if Product3 is produced,
then there must be a minimum of 225 and a maximum of 325 of Product3 produced.
1o part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1o part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Suppose we now change the additional constraint from part 1o (immediately above) to be
that, if Product3 is produced, then
there must be a minimum of 300 and a maximum of 450 Product 3 produced,
and (also) the amount produced of Product3 must also be a multiple of 50.
1p part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1p part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Return to part n above.
Now suppose that we introduce the requirement that, if Product 2 is produced, then the
amount of Product 2 produced must be one of 102, 103, 105, 107, 111 and we also introduce
the further additional requirement that, if Product 4 is produced, then the amount produced of
Product4 must be one of 320, 330, 350, 370, 410.
1q part 1) What is the optimal amount to be produced of each of Product1,
Product2, Product3, Product4, Product5?
1q part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
6
Remove these most recent additional constraints and again return to part n above.
Suppose we now add the requirements that
Product1 and Product2 are produced in equal abundance,
Product4 and Product5 are produced in equal abundance,
if Product 3 is produced then neither product 1 nor product 2 is produced,
if Product 3 is produced then at least 10 and at most 100 of Product 5 are produced.
1r part 1) What is the optimal amount to be produced of each of Product1, Product2,
Product3, Product4, Product5?
1r part 2) What is the optimal value of the objective function?
For both part 1 and part 2, (in keeping with note 4,) clearly show all working.
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
7
Question 2 – Transshipment and networks [2 + 3 + 6 + 4 + 3 + 3 + 3 + 3 + 3 + 2 =
32 marks]
Suppose we have a product (possibly masks, possibly shields, possibly containers of hand
sanitiser) that we wish to move from two locations (let’s call them node 1 and node 2, both
with a supply of 75) to two other locations (let’s call them node 7 and node 8, with demands
of 80 and 70 respectively).
We initially assume the transportation costs along edges in the network to be as follows:
From To Unit Cost ($)
Students are expected and required to address question 2 in terms of linear programming (LP)
and - if required - the closest possible variants.
2a) State the variables, and use these variables to state the objective function that we wish
to optimise. (We assume that the cost is something that we wish to minimise.)
2b) How many variables are there? Informally in terms of the network, being as specific
as you can, what do the variables correspond to?
2c) Solve the problem of the flow along edges giving the minimum cost.
Show the amounts of flow along the edges. State the value of the objective function.
State the number of edges with non-zero flow (and, for ease of reference, call this e2c
).
2d) Assuming that the number of edges with non-zero flow is less than e2c
(equivalently,
less than or equal to e2c
- 1), again solve the problem of the flow along edges giving the
minimum cost.
Show the amounts of flow along the edges. State the value of the objective function.
State the number of edges with non-zero flow.
8
2e) If the problem is to have a solution of finite cost (any possible solution at all) in
which goods get from the source/supply/starting points to the demand/sink destination points,
what is the smallest number of edges that can have non-zero flow for such a solution to
occur?
Hint: One way of doing this is to introduce a very large penalty for each edge with non-zero
flow.
In that case (if we require that only this smallest possible number of edges be used), what is
the minimum such cost? (If you followed the hint immediately above, then make sure to
remove the newly introduced large penalty when giving your answer.)
2f) Return to the problem from parts a, b and c above.
Due to maintenance problems along the edge between node 4 and node 5, the unit cost of
using this edge is $40/unit up to 30 units, then $60/unit thereafter.
Show how to solve this problem. In keeping with note 4, solve this problem.
2g) Following on from part f above, due to further maintenance problems along the edge
between node 4 and node 5, the unit cost of using this edge is $40/unit up to 30 units, then
$60/unit up to 55 units (i.e., we could have 30 units @ $40/unit and 25 units @ $60/unit, as
30 + 25 = 55), then $110/unit thereafter.
Show how to solve this problem. In keeping with note 4, solve this problem.
2h) We modify the original problem from parts a, b and c to be a shortest path problem.
The edge costs (from parts a, b and c) should now be assumed to be the length of the edge.
What is the shortest path from node 2 to node 8, and what is the length of the path?
Show how to solve this problem. In keeping with note 4, solve this problem.
2i part 1) Following on from part h, how would you modify your answer if we require that
the path from node 2 to node 8 has to go through node 5?
2i part 2) Following on from part h, how would you modify your answer if we require that
the path from node 2 to node 8 has to go through node 6?
Show how to solve this problem. In keeping with note 4, solve both parts of this problem.
Following on from the themes of part h and part i above, we now ask an open question worth
bonus marks. (The motivation might be that someone has to collect face masks and shields
on their way to a destination, but the order in which they collect them doesn’t matter.)
2j) Suppose we have a start node (call it A), and a destination node (call it D) and two
intermediate nodes (call them B and C respectively) that we have to go through. Suppose also
that we are allowed to go A to B to C to D and we are also allowed to go A to C to B to D,
and that this is not known or specified in advance. How might we set this up as a linear
programming (LP) problem?
We do not require a complete solution for 2j immediately above but wish you to explain in
detail how you would set this up.
9
Throughout, recall note 4 above: ``Note 4: As a general rule, don’t just give a number or an answer like
`Yes’ or `No’ without at least some clear and sufficient explanation - or, otherwise, you risk being awarded 0
marks for the relevant exercise. Evidence of working is expected to be shown. Make it easy for the person
marking your work to follow your reasoning. Evidence of working includes - but is not limited to - showing
clearly relevant spreadsheet tabs for every question and sub-question requiring calculations. Please understand
that a failure to require a spreadsheet tab when one is relevant for a question or sub-question could result in very
few - or potentially even zero - marks for the relevant question or sub-question. Your .pdf should typically
cross-reference the corresponding answer in your spreadsheet. For each sub-question and exercise, provide a
clearly labelled spreadsheet tab with clear content and appropriate use of colours, accompanied with clearly
cross-referenced clear .pdf explanation. Put another way, make sure that everything in your assignment is there,
and make it easy for the marker to find it. Again, without clear cross-reference between .pdf and spreadsheet tab,
there is the possibility that any such exercise will be awarded 0 marks.’’
Question 3 – Economic Order Quantity (EOQ) [10 marks]
Suppose that we have an ordering problem with variable costs.
We have a deterministic annual demand of 1000. The cost of placing an order (of any
positive non-zero amount) is $21 for an order. The holding cost of storing items is 25% (or
1/4) per annum of the cost of the goods. (Equivalently, if we wish to change from a year’s
annual demand to the demand over 10 years in a decade, the deterministic demand in a decade
would be 10,000 and the holding cost would be 250% of the cost of the goods. It will be safe
to address the problem in terms of years rather than decades.) As many goods as required can
be held in inventory indefinitely and not be thrown away.
The cost of each good is $4.00 up to 794 units ordered. If we order from 795 up to 1099, we
get a 5% discount and the cost of each good is $3.80. If we order from 1100 up to 1859, we
get an 8% discount and the cost of each good is $3.68. If we order 1860 or more, we get a
15% discount and the cost of each good is $3.40.
What is the optimal order quantity and the optimal total annual cost?
In keeping with note 4, clearly show all working.
A note about your Spreadsheet Model
When building your model, bear in mind the goals and guidelines for good spreadsheet design
as discussed in Lecture 3. Marks are given for good spreadsheet design. Marks will possibly
also be given for originality. Format both your models clearly with comments (and, if
possible, shading), etc. so that it is easy for the user to distinguish which cells are occupied by
decision variables, LHS and RHS constraints, and the objective function. Include a textbox in
each worksheet that describes the formulation in terms of cell references in your model.
Instructions:
You are to upload your submission on the FIT5097 Moodle site and should include the
following:
1. A text-based .pdf document (save as:
FamilyName-StudentId-2ndSem2020FIT5097.pdf) that includes all your answers to
Questions 1 and 2 and 3 (except for the Microsoft Excel Solver part of each
question); and
10
2. A Microsoft Excel workbook (save as:
FamilyName-StudentId-2ndSem2020FIT5097.xlsx) that includes the following
spreadsheets:
i. the spreadsheet model for Question 1;
ii. Sensitivity Rep – the sensitivity report for the Question 1 model (and any other
relevant parts);
iii. other relevant things (including any calculations) for Question 1;
iv. relevant things (including any calculations) for Question 2
v. relevant things (including any calculations) for Question 3
vi. etc.
vii. Anything else you deem sufficiently relevant.
Recall that, at the time you submit (1 and 2) to Moodle, the text-based .pdf will undergo a
similarity check by Turnitin. This is done at the time you upload your assignment to Moodle.
It is also our intention to perform such a check on your .xls/.xlsx file at the same time.
(This ends the submission instructions. Please read them and the notes on pages 1-2
carefully. Also recall that, as a general rule, when answering questions, don’t just give a
number or an answer like `Yes’ or `No’ without at least some clear and sufficient
explanation.)
Late penalties:
Work submitted after the deadline (possibly with a small amount of grace time) will be
subject to late penalties in accordance with the FIT5097 Unit Guide and Faculty and
University policies, and (unless any of the following contravenes the relevant policies)
certainly no less than 5% per calendar day, possibly as much as 10% per calendar day.
If you do not submit matching .pdf and .xls/.xlsx files (e.g., if you submit two files but one is
blank or unreadable, or if you only submit one file), then your work will be deemed late - and
will be subject to the relevant penalties, possibly receiving a mark of 0.
Work submitted 10 or more calendar days after the deadline will be given a mark of 0.
Plagiarism declaration:
You are required to state explicitly that you have done your own work, however the Moodle
assignment submission details permit you to declare this.
For example, if you are presented with an 'Assignment Electronic Plagiarism Statement', then
you are required to complete the 'Assignment Electronic Plagiarism Statement' quiz on the
FIT5097 Moodle site and accept the Student Statement (electronic version of the Assignment
cover sheet). If you do not accept the Student Statement, then your assignment may not be
marked, and you may be given a mark of 0.
Recall instructions above and notes on pages 1 to 2 (including but not only, e.g., Note 4,
Academic Integrity, Special Consideration, make sure to hit the `Submit’ button, the
scheduled interview is compulsory if you want a mark of greater than 0, etc.), and please
follow these carefully.
And a reminder not to post even part of a proposed partial solution to even part of an item
open for assessment to Ed Discussions, a Moodle forum or other public location. You are
reminded that Monash University takes academic integrity very seriously.
*** END FIT5097 Assignment Faculty of I.T., Monash University 2
nd
semester 2020 ***
11