How much could be price of this one
Page 5 of 5 Assessment Details and Submission Guidelines School Business Course Name Master of Professional Accounting Unit Code MA609 Unit Title Business Analytics and 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 100 Marks (this will be scaled down to 30%) Word limit Not applicable Release Date Week 5 Due Date Week 11 Submission Guidelines All work must be submitted on Moodle by the due date along with a completed Assignment Cover Sheet. For Melbourne students: use Melbourne Campus Submission link. For Sydney students: use Sydney Campus Submissions link. Reference sources must be listed appropriately at the end in a reference list using APA referencing style. 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/specialconsiderationdeferment 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. Assessment Cover 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; 1. certify that this assessment has not been submitted previously for academic credit in this or any other course; 1. I/we have read the MIT’s Plagiarism and Academic Misconduct Policy Procedure, and I/we understand the consequences of engaging in plagiarism; 1. 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. You will need to use linear programming to formulate and model a problem, and Excel solver will be used to conduct the analytics and obtain the solutions. For the assignment, you are required to form a group of 3 students. Each group needs to select a company from the list below and use the company’s website to collect some background information and any type of preliminary information 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 company of your choice, therefore you will need to use the company’s background information along with business analytics knowledge to formulate the problem. For instance for an airline the problem could be the assignment problem with assigning of terminals, airplanes, flights and pilots. Accordingly and based on the preliminary information that you collect, you need to make assumptions and build up a model for the company and solve the problem. The assignment should be formulated based on any of Transportation, Transshipment, or Assignment problems (you just need to do one out of these three options). You can choose any company from the below list in 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/organisations and possible approaches to problem solving: Transportation problem by manufacturing and mining companies: ADANI Mining (Transportation of minerals from origin to destination) Honda (Transportation of parts from manufacturers to dealers) Nissan (Transportation of parts from a manufacturer to dealer) Transshipment problem by manufacturing companies: Audi (Transportation of parts from manufacturers to dealers) Mercedes (Transportation of parts from manufacturers to dealers) BMW (Transportation of parts from manufacturers to 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) Assignment requirement: · choose a company from the list or assume your 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 Programming problem (LP) · After formulating the problem define the following: · Define decision variables · Define objective functions · Define constraints · Implement the model · 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 Assignment structure: · 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 problem to be analysed · Model design: · Formulation of Linear Programming 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: · Present solved problem using excel solver · Recommendation and conclusion · Structure and presentation of the assignment · Appendix (should include both 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. MA609 Business analytics and data Intelligence Project [Group] Marking Guide (30 Marks) Criteria Possible Marks Marks Allocated Introduction to the company: · A brief information around the company/business Comment: 5% Selection of the company · assumptions about the problem before formulating the problem and modelling Comment: 5% Problem Definition: · Identification and description of the problem to be analysed Comment: 10% Model design: · Formulation of Linear Programming (LP) problem OR · Defining decision variables · Defining objective functions · Defining constraints Comment: 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 results Comment: 30% Indication of optimal solution to the problem: · Present solved problem using excel solver Comment: 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: Page 2 of 3 Assessment Details and Submission Guidelines School Business Course Name Master of Professional Accounting Unit Code MA609 Unit Title Business Analytics and Data Intelligence Assessment Author Dr Ken Mardaneh Assessment Type Presentation[Group] Assessment Title Presentation[Group] Unit Learning Outcomes covered in this assessment b. Analyse critically, reflect on and synthesise techniques of data visualisation and data mining. c. Demonstrate advanced and integrated understanding of business analytical models. Weight 10% Total Marks 100 Marks (this will be scaled down to 10%) Word limit Not applicable Release Date Week 5 Due Date Week 11 Submission Guidelines All work must be submitted on Moodle by the due date along with a completed Assignment Cover Sheet. For Melbourne students: use Melbourne Campus Submission link. For Sydney students: use Sydney Campus Submissions link. Reference sources must be listed appropriately at the end in a reference list using APA or IEEE referencing style. 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/specialconsiderationdeferment 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. Assessment Cover 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; 1. certify that this assessment has not been submitted previously for academic credit in this or any other course; 1. I/we have read the MIT’s Plagiarism and Academic Misconduct Policy Procedure, and I/we understand the consequences of engaging in plagiarism; 1. 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: Presentation Each group needs to present the findings of the group project. Visual representation takes the form of power point slides and includes one or more of the following: charts, graphs, statistics, pictures, photos or other graphics are used in the power point slides.You must cover relevant items on any required project task and make reference to them. This must include indicating steps for each analytics task. Presentation should also be professional. Note: Presentation is an assessment task and PPT file need to be submitted for marking. MA609 PRESENTATION MARKING GUIDE [100 Marks = 10%] Criteria Possible Marks Comments Marks Allocated Fulfilment of the requirements of the task: Accuracy of problem identification Content · Relevance- based on task