Develop a quantitative model (linear programming) using the data, analyse and interpret the model using excel solver and report your findings.
need to develop a quantitative model (linear programming) using the data, analyse and interpret the model using excel solver and report your findings. You need to identify an objective function clearly stating the purpose of the quantitative model. You should be able to define the variables under consideration for the quantitative model development. Further, you should be to collect relevant information from stakeholders for developing the constraints. The report should outline the stakeholder’s analysis for data collection and developing constraints. The developed model should be analysed using the Excel solver function to generate an optimal solution. The report should outline the step-by-step procedure of the solver function. The final output should be presented to management for decision analysis.
Requirements:
MASTER OF BUSINESS ADMINISTRATIONMBA 6204Assessment GuideQuantitative Support of Decision MakingMBA 6204ASSESSMENT GUIDEQuantitative Support of Decision Making
2Assessment OverviewFor the assessment of MBA UNIT 6204, There are the four assessment tasks you have to fulfil in order to complete in MBA 6204 Unit. Details are given in Unit descriptor and also on “Studyboard@VIT”. Assessment will be done with the following time table:No.Assessment NameDate OpenDate of Submission1Discussion Participation20% weightageNo date,will be evaluated at the end 5 weeksWeek 2, 3, 4, 5Sunday by 11.55pm2Individual Report40% weightageWeek 4Week 4Sunday by 11.55pm3Strategic Report: Group Project40% weightageWeek 6Week 6Sunday by 11.55pm Each week, you will be guided by our LMS on all the course requirements of our MBA unit including what to do in that particular week, and how to fulfi l task requirements. For each assessment, the “Studyboard@VIT” will provide details on the assessment task and guidelines including how you will be assessed on each assessment task, marking criteria and so on. Some clarification on each assessment: 1. Assessment 1: Discussion Participation Discussion Participation: You will be assesses based on your accessible login on LMS, using the CHAT on the LMS. Also your interaction through email etc. with faculty and coordinators here in Australia. No assessment can be done by any other facilitator. 2. Assessment 2: Individual ReportIndividual Report on Quantitative Model Development: Students will develop a Quantitative model to analyse a specific managerial problem faced by their organization. Students will need to demonstrate their knowledge and ability to critically develop the model objectives, the decision variables and the organizational constraints. The students must prepare a brief report to demonstrate their ability using solver function to generate an optimal solution and assist their management in decision making.3. Assessment 3: Strategic ReportQuantitative support of decision making: Collaborative Group Project on Application of Quantitative techniques for managerial decision making. This is a group Assessment. Students will normally work in a group of 2 to 3 students. Students will build on a portfolio of specific strategic problems and develop a range of quantitative measures to resolve the strategic issue. They will also build a report to the strategic managers for optimal decision making.
3The following instructions are strictly applied throughout our MBA programme: › 1. The assessments are an important part of unit progression and are to be attended to diligently. Hence, no attempt at an assessment task means no marks.› 2. No assessment is allowed beyond a time limit as given and announced and therefore, to be submitted in time. Late submission would attract 10%-mark deductions for each day late submission.› 3. Assessment guidelines must be followed as per the guidelines provided. For example, if the assessment is on writing report with 2000 words, it must be like that, pages are not important but word count are necessary In case, word count exceeds more than 10% or 10% less of the specified word count, it will consider with 10% mark deductions.› 4. All assessment to be submitted to VIT, Australia and will be checked, marked and provided with feedback. No assessment can be done anywhere other than VIT, Australia.› 5. Assessment can be submitted on LMS or email to VIT or to local invigilator who will be scanning the assignments/answer papers and will submit on the same day to VIT, Australia.› 6. Total weight of assessment and marking will be done as overall.› 7. Students are required to clear 50% of the overall marks to pass the unit.› 8. The authorised agent/local facilitator can help student understand the assessment parts and also will be appointed as “Invigilator” (supervision only) for the assessment.Note: For all assignments, the preferred layout is in 12-point Calibri, with 1.5 line spacing, 5 centimetres left-hand margins and bold headings. Whenever you use the ideas and arguments of other writers, you must make reference to the writers and their work. By acknowledging the work of others, you avoid plagiarism. The APA style requires a reference list at the end of your assignment. It is arranged in alphabetical order by author surname.For further clarifi cation you can contact the coordinator via email.Further details on each assessment for MBA 6204 can be found on the following pages.
4Assessment 1Discussion Participation • Weightage 20% Student Guidelines› 1. In this class, online discussions will count towards your assignments grade in the course. The purpose of the discussion board is to frame and promote collaborative learning. Active and regular participa- tion is not only important for lecture to see, but also important for you in learning the course content and in developing your thoughts and positions on various topics. › 2. You are expected to participate on at least 3 differ- ent forums. You should begin at least one thread and provide at least three posts in response to other particIpants’ threads. Posting should be a minimum of one short paragraph and a maximum of two paragraphs. Word totals for each post should be in the 100-200 words range. › 3. While on discussion: you agree or disagree explain why with supporting evidence and concepts from the readings or a related experience. Include a reference, link, or citation when appropriate. › 4. While on discussion: Be organized in your thoughts and ideas. Incorporate correlations with the assig- ned readings or topics. Stay on topic. Provide evi- dence of critical and thoughtfulness in your re- sponses or interactions. Avoid summarizing. › 5. During the discussion: Contribute to the learning community by being creative in your approaches to topics, being relevant in the presented viewpoints, and attempting to motivate the discussion.› 6. In discussion: Be aware of grammar and sentence mechanics. Use proper etiquette.› 7. Remember that being respectful is critical at all times in the classroom, online and during forum chat discussions.The Assessor will assess you on the following:Discussion and Participation:a. Are made in a timely fashion, giving others an opportunity to respond.b. Are thoughtful and analyse the content or question asked.c. Pose new possibilities or opinions not previously voiced.d. Are Ideas expressed clearly and concisely. Uses appropriate vocabulary. Is attentive to spelling and grammar.e. Spend the time to construct creative, challenging and engaging discussion assignments, which promote participation.
CriteriaExcellent(A 80-100%)Very Good(B 70-79%)Good(C 60-69%)Pass(D 50-59%)Fail(N 0-49%)Marks Context and critical thinking• Comments always insightful & constructive.• Uses appropriate terminology.• Comments balanced between general impressions, opinions & specific, thoughtful criticisms, or contributions.• Comments mostly insightful & constructive.• Mostly uses appropriate terminology.• Comments are mostly relevant with the discussion.• Comments are occasionally insightful & constructive.• Occasionally use appropriate terminology.• Comments are occasionally too general or not relevant to the discussion.• Comments are sometimes constructive, with occasional signs of insight.• Student does not use appropriate terminology.• Comments not always relevant to the discussion.• Comments are uninformative.• Lacking in appropriate terminology.• Heavy reliance on opinion & personal taste.40%Disciplinary Knowledge• Disciplinary knowledge is clearly presented and uses disciplinary language authoritatively.• Shows critical understanding of the issue presented and demonstrates depth and accuracy of understanding.• Disciplinary knowledge is clearly presented and uses disciplinary language competently.• Shows a proficient awareness of the issue presented and demonstrates accuracy of understanding.• Disciplinary knowledge is presented and uses disciplinary language approaching competency.• Shows an awareness of the issue presented and demonstrates limited content understanding.• Disciplinary knowledge lacks clarity and uses disciplinary language tentatively.• Shows an awareness of the issue presented and some evidence of gaining new understanding.• Disciplinary knowledge is unclear and does not use the language of the discipline in a sustained fashion.• Demonstrates no evidence of gaining new understanding.40%Grammar and Vocabulary• Employs excellent discipline-based vocabulary relevant to the context and adheres to grammatical convention.• Employs a competent discipline-based vocabulary relevant to the context and adheres to grammatical convention.• Employs a developing disciplinary based vocabulary that adheres to the basic rules of grammar.• Demonstrates limited disciplinary based vocabulary that adheres to the basic rules of grammar, with a number of errors.• The task largely reverts to the use of non-discipline specific vocabulary with grammatical errors that interfere with meaning.20%Timely participationIt is important to check how student has been manage timing and promptnessTotal marks100%CommentsWeightage 20% =Lecturer’s Signature: Date: / / Name: 5MBA 6204 – Assessment 1 • Forum Discussion Rubric FOR FACULTY MEMBER ONLY Assessment Task: Forum Discussion • Weightage: 20% Name of the Student: Student No: Lecturer’s Observation on Student Participation:
6Assessment 2Individual Report • Weightage 40% Student GuidelinesThis is an individual assessment and you must choose one of the managerial problem as listed below that relate to your organization or another organization of your choice. You need to research all the data that will support management in such a way that they will have sufficient data and information that they are able to make the decisions appropriately.You also need to develop a quantitative model (linear programming) using the data, analyse and interpret the model using excel solver and report your findings. You need to identify an objective function clearly stating the purpose of the quantitative model. You should be able to define the variables under con-sideration for the quantitative model development. Further, you should be to collect relevant information from stakeholders for developing the constraints. The report should outline the stakeholder’s analysis for data collection and developing constraints. The devel-oped model should be analysed using the Excel solver function to generate an optimal solution. The report should outline the step-by-step procedure of the solv-er function. The final output should be presented to management for decision analysis. You are required to set up the MS Excel dashboard to assist any user to make decisions. You are to provide quantitative model for managerial decision making with optimal outcomes for the organization by using Excel solver tools and validate the importance of spe-cific analysis and interpretation for the management decisions. Your submission will include two submissions:Report (1500 words) + Excel work fileThe managerial decisions you make in relation to this assessment must be made with regards to any one of the following:› 1. Make or buy product or equipment› 2. Financial decision making: Investment portfolio problem› 3. Transportation/Assignment problem› 4. Blending Problem/Marketing Mix problem› 5. Production/Inventory Planning problem› 6. Multiperiod Cashflow Problems› 7. Process/Job Sequencing Problem› 8. Other specific managerial problems…You will be assessed as follows:a. Structure of the written report: Background infor- mation is relevant, issues are logically ordered, recommendations clearly relate to the managerial problem.b. Identify critical managerial problem: Formulate linear programming model using variables, objec- tives and constraints.c. Analyse and test the issues: Able to mathematically analyse and test using Excel solver.d. Implement the solution: Justify by providing alterna- tives that the solution generated is the optimal. e. Write clearly and concisely: Arguments are explicit and succinct, appropriate headings are used, grammar and spelling are accurate.Submission formatting style guideFor all major assignments, both formative and sum-mative, the preferred layout is in 12-point Calibri, with 1.5 line spacing, 2.5 centimetres left-hand margins and Bold headings. All assignments must be submitted with a completed and signed cover sheet. Whenever you use the ideas and arguments of other writers, you must make reference to the writers and their work. By acknowledging the work of others, you avoid plagia-rism. The APA style requires a reference list at the end of your assignment. It is arranged in alphabetical order by author surname.
7MBA 6204 – Assessment 2 • Individual Report Rubric FOR FACULTY MEMBER ONLY Assessment Task: Individual Report • Weightage: 40% Name of the Student: Student No: Lecturer’s Observation on Student Participation: CriteriaExcellent(A 80-100%)Very Good(B 70-79%)Good(C 60-69%)Pass(D 50-59%)Fail(N 0-49%)Marks Quantitative Model Development & Context• Excellent logically developed model matched to the requirements of the task.• Generates a highly developed, focused, and sustained argument(s) related to the objectives, constraints and variables.• Uses logically developed model matched to the requirements of the task. • Generates developed and focused argument(s) related to the objectives, constraints and variables.• Uses somewhat logically developed model matched to the requirements of the task. • Generates few developed and focused argument(s) related to the objectives, constraints and variables.• Poor logic in structure of model development.• Poor development and focus of argument(s) related to the objectives, constraints and variables.• Paragraph structure is not clear, well ordered, or logical. • Generates a series of statements or claims without connecting these to form a clear, logical argument(s) related to the objectives, constraints and variables.15%15%Critical Thinking• Classifies multiple perspectives of stakeholders for employing model and integrating theory very well. • Explores relationships between component elements/ variables. • Integrates perspectives to develop clear model formulation for optimal solution.• Classifies perspectives of stakeholders and integrates some theory. • Explores relationships between component elements/ variables. • Integrates contrasting perspectives to develop model formulation for optimal solution.• Identifies, compares, and contrasts perspectives in a wider context with limited theoretical application. • Organises component elements/variables in a given framework. • Formulates a response that integrates perspectives for model development.• Poor comparison and contrast of key perspectives with limited theoretical application. Poor organisation of elements/ variables in a given framework. • Response does not integrate contrasting perspectives for model formulation.• Does not compare and contrast key perspectives. • Unable to organise elements/ variables in a given framework. • Response does not integrate contrasting perspectives on the issues. 10%10%5%Disciplinary Knowledge• Disciplinary knowledge is clearly presented and uses disciplinary language authoritatively.• Shows critical understanding of the issue presented and demonstrates depth and accuracy of understanding.• Disciplinary knowledge is clearly presented and uses disciplinary language competently.• Shows a proficient awareness of the issue presented and demonstrates accuracy of understanding.• Disciplinary knowledge is presented and uses disciplinary language approaching competency.• Shows an awareness of the issue presented and demonstrates limited content understanding.• Disciplinary knowledge lacks clarity and uses disciplinary language tentatively.• Shows an awareness of the issue presented and some evidence of gaining new understanding.• Disciplinary knowledge is unclear and does not use the language of the discipline in a sustained fashion.• Demonstrates no evidence of gaining new understanding.10%10%Grammar & Vocabulary• Employs excellent discipline-based vocabulary relevant to the context and adheres to grammatical convention.• Employs a competent discipline-based vocabulary relevant to the context and adheres to grammatical convention.• Employs a developing disciplinary based vocabulary that adheres to the basic rules of grammar.• Demonstrates limited disciplinary based vocabulary that adheres to the basic rules of grammar, with a number of errors. • The task largely reverts to the use of non-discipline specific vocabulary with grammatical errors that interfere with meaning.10%
8Referencing• Employs an accurate academic referencing convention citing multiple sources.• Employs an accurate academic referencing convention citing multiple sources, with some errors. • Employs a basic academic referencing convention appro priate to the discipline, with an adequate number of sources. • Employs a basic academic referencing convention ap propriate to the discipline with limited sources.• Shows unfamiliarity with, and inconsistent application of the conventions of academic referencing with inadequate sources.15%Total marks100%CommentsWeightage 40% =Lecturer’s Signature: Date: / / Name:
9Assessment 3Strategic Report: Group Project • Weightage 40% Student GuidelinesIn Assessment 3 you are to prepare a Collaborative report based on quantitative issues faced by the sev-eral functional departments (production, sales/mar-keting/finance/operations…) within an organisation (Choose a multinational organization). The group has to identify at least three unique functional areas for that organization where they are able to utilize three unique quantitative modelling techniques for support-ing decision making with a strong justification report for its implementation within the various functional areas of the organization. A consultative report is to be developed for strategic management describing the implementation plan for introducing the quantitative modelling technique supporting quality decision making. This report shall highlight the importance of different spreadsheet modelling techniques for strategic decision making.Your report needs to take into consideration thefollowing aspects:› 1. The Key Business initiative (Stated Target) of your organisation and its background› 2. The key issues faced within the functional unit (Finance, Operations, HR, Marketing/sales) of the organisation.› 3. Develop key Targets (goals and objectives) for the report in terms of maximizing/Minimizing costs/ revenues/improving ROI.› 4. Developing case for selected functional units and using suitable quantitative model for supporting quality managerial decision making .› 5. Stakeholder analysis for determining the strategic objectives, key constraints and selecting suitable measures of success in reaching the optimal solution.› 6. Implementation Plan including Steps and Mile stones to reaching your Target for the next 12 months.› 7. Some theoretical basis for your solutions and decisions.› 8. The Report should be written in appropriate business language so that your analysis and discus- sion have an objective tone.› 9. Your writing should be clear and concise and be in your own words.› 10. Use headings and sub heading to guide the reader.› 11. Use visual data representations to support your discussion.› 12. Report Conclusion.The Consultative Report (per team) must be in the range of 2,500 words in length excluding references. You must reference using the APA referencing style.Reflective Piece: A further 400 – 500 words reflection paper should be submitted per student.Reflections based on your experience and learning in this exercise and how this may be applied in your own organisation.Your submission will include two submissions:Group Report + Individual Reflective ReportYou will be assessed on the following:a. Research information: Appropriate sources are consulted, Sufficient sources are consulted, Sources are referenced.b. Organise information: Appropriate headings, write clearly and concisely using an integrated structure, arguments and conclusions match purpose.c. Develop and Explain: Case issues in depth and provide implementation plan for the organisation for improved decision making.d. Write clearly and concisely: Arguments are easy to understand and succinct.Submission formatting style guide:For all major assignments, both formative and sum-mative, the preferred layout is in 12-point Calibri, with 1.5 line spacing, 2.5 centimetres left-hand margins and Bold headings. All assignments must be submitted with a completed and signed cover sheet. Whenever you use the ideas and arguments of other writers, you must make reference to the writers and their work. By acknowledging the work of others, you avoid plagia-rism. The APA style requires a reference list at the end of your assignment. It is arranged in alphabetical order by author surname.
10CriteriaExcellent(A 80-100%)Very Good(B 70-79%)Good(C 60-69%)Pass(D 50-59%)Fail(N 0-49%)Marks Writing, Argument & Report Structure• Excellent, logically developed structure matched to the task. • Generates a highly developed, focused, and sustained argument(s) related to the report.• Uses logically developed structure matched to the task. • Generates developed and focused argument(s) related to the report.• Uses somewhat logical structure of paragraphs but with errors. • Generates few developed and focused argument(s) related to the report.• Poor logic in structure of paragraphs. • Poor development and focus of argument(s) related to the report.• Paragraph structure is not clear, well ordered, or logical. • Generates a series of statements or claims without connecting these to form a clear, logical argument.15%15%Disciplinary Knowledge• Disciplinary knowledge is clearly presented and uses disciplinary language authoritatively.• Shows critical understanding of the issue presented and demonstrates depth and accuracy of understanding.• Disciplinary knowledge is clearly presented and uses disciplinary language competently.• Shows a proficient awareness of the issue presented and demonstrates accuracy of understanding.• Disciplinary knowledge is presented and uses disciplinary language approaching competency.• Shows an awareness of the issue presented and demonstrates limited content understanding.• Disciplinary knowledge lacks clarity and uses disciplinary language tentatively.• Shows an awareness of the issue presented and some evidence of gaining new understanding.• Disciplinary knowledge is unclear and does not use the language of the discipline in a sustained fashion.• Demonstrates no evidence of gaining new understanding.15%15%Participation & Collaboration• An integrated contribution to the response to the task, which reflects critical assimilation of other group perspectives, reaching a balanced and well-founded conclusion, set of findings or recommendations.• A co-ordinated contribution to the response to the task, which reflects assimilation of other perspectives, reaching a qualified conclusion, set of findings or recommendations.• A response to the task which attempts to accommodate or draw upon each individual contribution in a coherent and structured fashion, reaching a tentative conclusion, set of findings or recommendations.• A response to the task, which reflects each individual contribution, and constructs a less than coherent, but plausible, conclusion, set of findings or recommendations.• Response does not account for other contributions or is unable to effectively include other points of view to reach a plausible conclusion.10%MBA 6204 – Assessment 3 • Case Study Analysis Rubric FOR FACULTY MEMBER ONLY Assessment Task: Strategic Report – Group Project • Weightage: 40% Name of the Student: Student No: Lecturer’s Observation on Student Participation:
11Weightage 40% =Lecturer’s Signature: Date: / / Name: Reflective Learning: Reporting, Responding, Relating, Reasoning & Reconstructing Thoughts• Excellently demonstrated the issues involved, explained why it happened, made clear observations and posed questions to address the issues.• Excellent attempt to build connection between issue and professional experience and disciplinary knowledge.• Excellently explained the underlying issues.• Explained the relevant theory and literature support.• Explained how and why they would apply the model with reconstructed thoughts.• Explained how the changes could be more beneficial.• Significantly demonstrated the issues involved, explained why it happened, made clear observations and posed questions to address the issues.• Significantly attempt to build connection between issue and professional experience and disciplinary knowledge.• Significantly explained the underlying issues.• Explained the relevant theory and literature support.• Explained how and why they would apply the model with reconstructed thoughts.• Explained how the changes could be more beneficial.• Demonstrates the issues involved, explained and fairly explains why it happened, made clear observations and posed questions to address the issues. • Good attempt to build connection between issue and professional experience and disciplinary knowledge.• Good attempt to explain the underlying issues.• Good attempt to explain the relevant theory and literature support. • Good attempt to explain how and why they would apply the model with reconstructed thoughts.• Good attempt to explain how the changes could be more beneficial.• Demonstrates the issues involved, explained.• Fair attempt to build connection between issue and professional experience and disciplinary knowledge.• Fairly explained the underlying issues.• Fairly explained the relevant theory and literature support. • Fairly explained how and why they would apply the model with reconstructed thoughts.• Fairly explained how the changes could be more beneficial.• Demonstrated the issues involved, but vaguely explained why it happened.• Weak attempt to build connection between issue and professional experience and disciplinary knowledge.• Weak attempt to explain the underlying issues.• Demonstrated weak attempt to explain the relevant theory and literature support.• Weak attempt to explain how and why they would apply the model with reconstructed thoughts.• Not much explanation as to how the changes could be more beneficial.5%5%5%5%5%5%Total marks100%
MASTER OF BUSINESS ADMINISTRATION© Copyright VIT (Victorian Institute of Technology) 2019-2020RTO No: 20829 | TEQSA Provider ID: PRV 14007 | CRICOS Provider Code: 02044E | ABN: 41 085 128 525
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
