Assessment Details and Submission Guidelines
|
School
|
Business
|
Course Name
|
MasterofProfessionalAccounting
|
Unit Code
|
MA609
|
Unit Title
|
BusinessAnalyticsand Data Intelligence
|
Assessment Author
|
Dr Ken Mardaneh
|
Assessment Type
|
Project[Group]
|
Assessment Title
|
Project[Group]
|
Unit Learning Outcomes covered in this assessment
|
a.Demonstrate advanced and integrated understanding of business and data Intelligence for organisational decision-making.b.Analyse critically, reflect on and synthesise techniques of data visualisation and data mining.c.Demonstrate advanced and integrated understanding of business analytical models.d.Critically analyse, synthesise and reflect on decision analysis techniques to develop optimal strategy.
|
Weight
|
30%
|
Total Marks
|
100Marks(thiswill bescaleddownto30%)
|
Word limit
|
Notapplicable
|
Release Date
|
Week5
|
Due Date
|
Week11
|
Submission Guidelines
|
•AllworkmustbesubmittedonMoodlebytheduedatealongwithacompleted
AssignmentCoverSheet.
•ForMelbournestudents:useMelbourneCampus Submissionlink.
•For Sydneystudents:useSydneyCampus Submissionslink.
•Referencesourcesmustbelistedappropriately attheendin areferencelistusingAPAreferencingstyle.
|
Extension
|
•If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School's Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at:
http://www.mit.edu.au/about
-
mit/institute
-
publications/policies
-
procedures
-
and
-
guidelines/special
considerationdeferment
|
Academic Misconduct
|
•Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at:http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure.For further information, please refer to the Academic Integrity Section in your Unit Description. |
AssessmentCover Sheet
Student ID Number/s:
|
Student Surname/s:
|
Given name/s:
|
|
|
|
|
|
|
|
|
|
|
|
|
Course:
|
School:
|
Unit code:
|
Unit title:
|
Due date:
|
Date submitted:
|
Campus:
|
Lecturer:
|
Tutor:
|
Student Declaration
I/We declare that: 1.the work contained in this assignment is my/our own work/group work, except where acknowledgement of sources is made;2.certify that this assessment has not been submitted previously for academic credit in this or any other course;3.I/we have read the MIT’s Plagiarism and Academic Misconduct Policy Procedure, and I/we understand the consequences of engaging in plagiarism;4.a copy of the original assignment is retained by me/us and that I/we may be required to submit the original assignment to the Lecturer and/or Unit Co-ordinator upon request;
I/we have not plagiarised the work of others or participated in unauthorised collaboration when preparing this assignment.
|
MIT ID
|
Signature
|
Date
|
|
|
|
|
|
|
|
|
|
|
|
|
For Assessor Use Only (if not marked on Moodle)
Name:
|
|
Position
|
|
Date:
|
|
Signature:
|
|
Marks/Grades:
|
|
Assignment Description:
The assignment is designed to allow you to demonstrate effective business analytics skills using optimisation methods.Youwill need touse linear programming to formulate and model a problem, and Excel solver will be used toconduct theanalytics and obtain the solutions.For theassignment,you are required to form a group of3students.
Each group needs to select a company from the list below and use the company’s website to collect some background information and anytype ofpreliminaryinformation that could help in formulating the optimisation problem of the company.For example you may find some information about a given company’s operations, their branches/wholesales, level of production, etc., that could help you with formulating the problem.
You will realise that there is no direct information about optimisation problems of the companyof your choice,therefore you will need to use the company’s background informationalong with business analytics knowledgeto formulate the problem. For instance for an airline the problem could betheassignmentproblem with assigningof terminals, airplanes, flights and pilots. Accordingly and based onthepreliminaryinformationthat you collect,you need to make assumptions and build up a model for the company andsolve the problem.
The assignment shouldbeformulated based onany ofTransportation,Transshipment, or Assignment problems(you just need to do one out of these three options). You can choose any companyfrom the below listin airline or Metro train industries (for assignment problem), in manufacturing or port shipment industries (for transhipment or transportation problem). Below is a list of companies/organisationsand possibleapproaches to problem solving:
Transportation problem by manufacturing and mining companies:
ADANI Mining(Transportation of minerals from origin to destination)
Honda(Transportation of parts from manufacturersto dealers)
Nissan(Transportation of parts from a manufacturer to dealer)
Transshipmentproblem by manufacturing companies:
Audi(Transportation of parts from manufacturersto dealers)
Mercedes(Transportation of parts from manufacturersto dealers)
BMW(Transportation of parts from manufacturersto dealers)
Assignment problem by companies/organisations:
Air Asia(assignment of terminals, airplanes, flights)
V-line(assignment of trains to different lines)
Melbourne royal hospital (assignment of nurses to different shifts)
St. Vincent hospital (assignment of surgeons, operating theatres based on availability)
Assignmentrequirement:
•choose a company from the list orassumeyour own company•make assumptions about the problem before formulating the problem and modelling(assumptions such as the type of operation, amount of manufacturing and shipment, cost, etc.)•Formulate a Linear Programmingproblem(LP)•After formulating the problem define the following:✓Define decision variables✓Define objective functions✓Define constraints•Implement the model✓Run the analysisusing Excel solver✓Prepare Excel output of the model using excel solver✓Run sensitivity analysisusing excel solverand interpret the results
Assignmentstructure:
•Introduction to the company•Selection of the company✓assumptions about the problem before formulating the problem and modelling•Problem definition✓Identification and description of the problemto be analysed•Modeldesign:✓Formulation ofLinearProgramming problem (LP)✓Defining decision variables✓Defining objective functions✓Defining constraints•Model implementation:✓Run the analysis using Excel solver✓Prepare Excel output of the model using excel solver✓Run sensitivity analysis using excel solver and interpret the results•Indication of optimal solution to the problem:✓Presentsolved problemusingexcel solver•Recommendation and conclusion•Structure and presentation of the assignment•Appendix(should includeboth assignment word document and Excel solver file)
Note: Students need to submit the assignment as a word document along with the Excel solver file used for the analyses.
MA609Businessanalyticsand data Intelligence Project[Group]Marking Guide (30Marks)
Criteria
|
Possible Marks
|
Marks Allocated
|
Introductionto the company: ✓A brief information around the company/businessComment:
|
5%
|
|
Selection of the company ✓assumptions about the problem before formulating the problem and modellingComment:
|
5%
|
|
Problem Definition: ✓Identification and description of the problemto be analysedComment:
|
10%
|
|
Modeldesign: ✓Formulation of LinearProgramming(LP)problemOR✓Defining decision variables✓Defining objective functions✓Defining constraintsComment:
|
30%
|
|
Model implementation: ✓Run the analysis using Excel solver✓Prepare Excel output of the model using excel solver✓Run sensitivity analysis using excel solver and interpret the resultsComment:
|
30%
|
|
Indication of optimal solution to the problem: ✓Presentsolved problemusingexcel solverComment:
|
10%
|
|
Recommendation and conclusion:
Comment:
|
5%
|
|
Structure and Presentation of the assignment:
Comment:
|
5%
|
|
Total
|
100%
|
|
Overall Comments:
Assessor Name:
Assessor Signature:
|
= _____/30__ Marks
Date:
|