IntelliAuto is an automobile parts manufacturer with 5000 employees. Specifically, the two automobile parts, namely XK-1010 and XP-1020, have evolved to be the top pro

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 1/6

Assessment 3: Prescriptive Analytics and Reflective Journal 30%

Due 12 Jun by 23:59 Points 30 Submitting a media recording or a file upload

Start Assignment

Assessment type: Report & Narrated Video

Word Limit: 1200 words (+/- 10%) excluding R scripts, appendix, etc. (see Assessment Details); Narrated Video (3 minutes)

Due Date: Sunday 23:59 (Melbourne time) – Week 14 (First Exam Week)

Weighting: 30%

Overview 

This assessment comprises of two parts: 

Part A – Case Study 

You are required to examine a case study, formulate and produce analytical model(s), interpret, draw conclusion(s) and provide recommendation(s) based on your analysis via a report to a business client. The case study is provided in Assessment Details. 

This assessment relates to the professional practice of business and/or data analysts, who perform prescriptive modelling technique(s) in response to requests from a business client or internal stakeholder. To complete this assessment task, you are required to demonstrate the ability to apply the prescriptive analytics techniques which you have learned so far in this course. Also, the purpose of this assessment is to demonstrate your ability to communicate the outputs of prescriptive analytics and deliver a report that can be used by others to make responsive and evidence-based business decisions.  

Part B – Reflective Journal 

You are required to produce a narrated video of a reflective journal which covers your learning journey of this course and how it associates with your personal and professional development.  

As the last piece of assessment of this course, the purpose of a reflective journal is to get you to think through and reflect on the lesson you have learned throughout the course. It is also important that you consider how the lesson could be integrated in your current personal development and future professional practice.  

Assessment criteria 

This assessment will measure your ability to: 

Ability to address the business problem(s) and objective(s) of the case study (5 pts)  Ability to identify and apply appropriate prescriptive analytics techniques (8 pts)  Ability to interpret and communicate evidence of the analysis with appropriate details (8 pts) 

Ability to deliver quality report with appropriate language, structure and style (4 pts)  Ability to reflect on the learning journey in relation to current personal development and future professional practice (5 pts) 

Course learning outcomes 

This assessment is relevant to the following course learning outcomes: 

CLO1  Explain how business analytics can be used to drive decision-making in organisations. 

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 2/6

CLO3  Apply appropriate business analytics techniques and tools to extract business insights. 

CLO4  Justify the effectiveness of business analytics techniques and tools in informing decision-making in different contexts. 

CLO5  Communicating business insights to inform responsive and evidence-based decision-making. 

Assessment details 

IntelliAuto is an automobile parts manufacturer with 5000 employees. Specifically, the two automobile parts, namely XK-1010 and XP- 1020, have evolved to be the top products in the marketplace. XK-1010 is marketed as a smart buy for middle-class customers with tight budget and it generates profit of $3500 for IntelliAuto. On the other hand, XP-1020 is marketed as a privilege of affluence, targeting upper-middle class customers and it generates a healthy profit of $5500 for the organisation. 

Assama Gupta, the head of manufacturing department at IntelliAuto, is currently deciding the production schedule for the upcoming month. To meet one of the department’s key performance indicators (KPIs), Assama needs to decide how many XK-1010 and XP- 1020 to produce so that the profit of IntelliAuto could be maximised.  

Considering the resources, he understands the department has a capacity of 50,000 labour hours during the upcoming month. In addition, he also learns that it takes about 6 labour hours to complete a XK-1010 and 8.5 labour hours to complete a XP-1020. There are certain materials required to manufacture the automobile parts. Specifically, aluminium is the key material to produce both XK- 1010 and XP-1020. The aluminium supplier has informed Assama that he can only receive a maximum of 25000 tonnes for the upcoming month as the supplier could not meet its production schedule for next month. This was due to the identification of several positive COVID-19 cases among the production staff at the supplier and therefore a forced shutdown for two weeks. Aluminium requirement to complete a XK-1010 is 3 tonnes and aluminium requirement to complete a XP-1020 is 2 tonnes.

As far as he knows, the demand for a variety of automobile parts has gradually increased over the past few months. Not until recently that Assama has been provided a forecast of the monthly demands for different automobile parts. It has been suggested from the forecast report that the demand for XP-1020 has increased from 2500 to its maximum, which is 3800 units. However, there is no limitation for the demand of XK-1010.  

Assama needs to determine the following issues

A. How many XK-1010 and XP-1020 should be produced to achieve the optimal profit and how much is the optimal profit? Assama needs to know how much labour hours and aluminium used and/or unused. 

B. The marketing department at IntelliAuto has informed Assama that a targeted $400,000 advertising campaign will possibly raise the demand for XP-1020 from 3800 to 4200. Together with the head of marketing department, Assama would like to know if the marketing campaign should be pursued and if it should, they would like to know how much additional profit could be generated.  

C. IntelliAuto production can produce two other automobile parts called XL-1060 and XF-1090. XL-1060 consumes 7 units of labour and 10 units of aluminium and generates a profit of $4800. XF-1090 consumes 6.9 units of labour and 2 units of aluminium and generates a profit of $3900. Assama wants to know if it is profitable to produce XL-1060 and XF-1090 in addition to XK-1010 and XP-1020?

As a forward thinker, Assama has convinced the executive team on his plan to investigate and seek advice from a consulting firm to solve his issues. You have been engaged as a Business Analytics consultant to produce a report which includes the recommendation(s) to Assama.  

Guidelines: 

Some guidelines for completing Part A – Case Study are provided below.  

Part 1 – Prescriptive Analytics 

To complete this assessment task, you are expected to demonstrate the use of Excel Solver to solve the problem(s) described in the case study. Besides the discussion on the business problem(s) and objective(s), you need to present the problem formulation in your report and clearly explain the mathematical model for every question. To demonstrate your problem solving process, you could

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 3/6

discuss how you have implemented the prescriptive model(s) in Excel. Discuss your solution(s) and/or sensitivity analysis result(s) of your prescriptive model(s) before you suggest any actions to the business client under recommendations.  

Part 2 – Report 

Word Limit: 1200 words (+/- 10%), excluding Table of Content, Appendix, References, figures and tables. Note that anything beyond word limit will not be marked.  

Font Size: 11pt or 12pt  

Font Style: Calibri or Times New Roman 

Document Margins:  2.5cm for top, bottom, left and right  

Spacing: Single or 1.5 spacing 

Some notes and guidelines: 

The report should include Introduction, Problem Formulation, Discussions, Recommendation(s) and Conclusion(s).   The report covers a wider audience, including management and business users as well as data analysts.   Use headings for each section and subsection (i.e. 1.0 Introduction, 1.1. Business Background, 1.2. Objectives, 2.0 Problem Formulation, etc.).   Label the figures and tables in the report properly.  

Produce a Table of Content.  Use Appendix as you see fit.   Use References as you see fit. See next section about referencing guidelines.  

Part B – Reflective Journal 

The reflective journal requires you to reflect on the development of your ideas and insights about lesson you have gained from this course. You also need to consider how the lesson learned could be integrated in your current personal development and future professional practice. As a brief guide, you may want to look at the following but not limited to: 

Consider key concepts, theories, skills, insights, practices, exercises, mistakes and conversations with peers that may have benefited your current personal development.  Consider how your course learning experiences (e.g. group work, peer learning, etc.) might enhance your future professional practice.   Consider what capabilities you have developed from this course that may provide you with an advantage in your future profession or career.  

Please note the following: 

PowerPoint slides are not required.  Show your face during the recording of the narrated video. 

Referencing guidelines 

Use RMIT Harvard (https://www.rmit.edu.au/library/study/referencing/referencing-guides-for-printing)  referencing style for this assessment. 

You must acknowledge all the courses of information you have used in your assessments.  

Refer to the RMIT Easy Cite (https://www.lib.rmit.edu.au/easy-cite/)  referencing tool to see examples and tips on how to reference in the appropriated style. You can also refer to the library referencing page for more tools such as EndNote, referencing tutorials and referencing guides for printing.  

Submission format 

You need to submit the following documents of your assessment in Canvas: 

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 4/6

Assessment 3: Prescriptive Analytics and Reflective Journal

1. report in a single PDF file;   2. Excel file  3. Narrated video (maximum 3 minutes of mp4 file) 

Extensions

If your assessment preparation has been impeded by unforeseen circumstances (such as illness, injury, unexpected work commitments or career responsibilities) you may be eligible for an extension.

Requests for extensions must be emailed to the course coordinator ([email protected] (mailto:[email protected]) ) at least one working day before the assessment deadline using the extension request form (available from Extensions – RMIT University (https://www.rmit.edu.au/students/my-course/assessment-results/special-consideration-extensions/extensions) ).

If you are seeking an extension on or after an assessment due date, or you require an extension of more than 7 days, you must apply for special consideration. This is a confidential process. Please see the RMIT extensions website for details regarding grounds for extensions and special consideration and the required supporting documentation.

Academic integrity and plagiarism 

Academic integrity is about honest presentation of your academic work. It means acknowledging the work of others while developing your own insights, knowledge and ideas. 

You should take extreme care that you have:  

Acknowledged words, data, diagrams, models, frameworks and/or ideas of others you have quoted (i.e. directly copied), summarised, paraphrased, discussed or mentioned in your assessment through the appropriate referencing methods   Provided a reference list of the publication details so your reader can locate the source if necessary. This includes material taken from Internet sites  

If you do not acknowledge the sources of your material, you may be accused of plagiarism because you have passed off the work and ideas of another person without appropriate referencing, as if they were your own.  

RMIT University treats plagiarism as a very serious offence constituting misconduct.  

Plagiarism covers a variety of inappropriate behaviours, including: 

Failure to properly document a source  Copyright material from the internet or databases  Collusion between students 

For further information on our policies and procedures, please refer to the University website. (https://www.rmit.edu.au/students/student-essentials/rights-and-responsibilities/academic-integrity)  

Assessment declaration 

When you submit work electronically, you agree to the assessment declaration. (https://www.rmit.edu.au/students/student- essentials/assessment-and-exams/assessment/assessment-declaration)  

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 5/6

Criteria Ratings Pts

5 pts

8 pts

8 pts

4 pts

Criterion 1 Ability to address the business problem(s) and objective(s) of the case study.

5 to >4.0 Pts HD

Comprehensive coverage of the business problem(s) and objective(s) with convincing articulation.

4 to >3.5 Pts DI

Thorough coverage of the business problem(s) and objective(s) with clear articulation.

3.5 to >3.0 Pts CR

Good coverage of the business problem(s) and objective(s) with satisfactory articulation.

3 to >2.5 Pts PA

Limited coverage of the business problem(s) and objective(s) with weak articulation.

2.5 to >0.0 Pts NN

No or very limited coverage of the business problem(s) and objective(s) with poor articulation.

0 Pts DNS

Did not submit.

Criterion 2 Ability to identify and apply appropriate prescriptive analytics techniques.

8 to >6.4 Pts HD

Demonstrates an exceptional understanding in formulating and applying appropriate prescriptive model(s). Provides rigorous, detailed and insightful analysis that is highly organised and contains no error.

6.4 to >5.6 Pts DI

Demonstrates a very good understanding in formulating and applying appropriate prescriptive model(s). Provides detailed and insightful analysis that is well organised and contains very few errors.

5.6 to >4.8 Pts CR

Demonstrates a satisfactory understanding in formulating and applying appropriate prescriptive model(s). Provides detailed and somewhat insightful analysis that is reasonably organised and contains few errors.

4.8 to >4.0 Pts PA

Demonstrates a limited understanding in formulating and applying appropriate prescriptive model(s). Provides basic analysis that is disorganised and contains some errors.

4 to >0.0 Pts NN

Demonstrates no or very limited understanding in formulating and applying appropriate prescriptive model(s). Provides poor analysis that is highly disorganised and contains numerous errors.

0 Pts DNS

Did not submit.

Criterion 3 Ability to interpret and communicate evidence of the analysis with appropriate details.

8 to >6.4 Pts HD

Provides outstanding discussions, conclusion and recommendation(s) that have actionable, novel and carefully considered details and insights.

6.4 to >5.6 Pts DI

Provides very good discussions, conclusion and recommendation(s) that have comprehensive details and insights.

5.6 to >4.8 Pts CR

Provides satisfactory discussions, conclusion and recommendation(s) that have sufficient details and insights.

4.8 to >4.0 Pts PA

Provides limited discussions, conclusion and recommendation(s) that have insufficient details and insights.

4 to >0.0 Pts NN

Provides no or very limited discussions, conclusion and recommendation(s) that have insufficient and/or unclear details and insights.

0 Pts DNS

Did not submit.

Criterion 4 Ability to deliver quality report with appropriate language, structure and style.

4 to >3.2 Pts HD

Overall quality of the use of language, style and structure of the report is truly professional, cohesive, creative, engaging, has an excellent structure and contain no error.

3.2 to >2.8 Pts DI

Overall quality of the style and structure of the report is truly professional, very easy to follow, has a very good structure, and contains very few errors.

2.8 to >2.4 Pts CR

Overall quality of the use of language, style and structure of the report is professional, easy to follow, has a good structure, and/or contains few errors.

2.4 to >2.0 Pts PA

Overall quality of the use of language, style and structure of the report is somewhat professional, somewhat easy to follow, has a loose structure, and/or contains some errors.

2 to >0.0 Pts NN

Overall quality of the use of language, style and structure of the report is unprofessional, difficult to follow, has no structure, and/or contains numerous errors.

0 Pts DNS

Did not submit.

2022/5/31 06:52 Assessment 3: Prescriptive Analytics and Reflective Journal 30%

https://rmit.instructure.com/courses/94023/assignments/685077 6/6

Total points: 30

Criteria Ratings Pts

5 pts

Criterion 5 Ability to reflect on the learning journey in relation to current personal development and future professional practice.

5 to >4.0 Pts HD

Rigorously and perceptively identify and explore the lesson learned. Rigorously and perceptively discuss how the lesson learned can be integrated in your current personal development and future professional practice.

4 to >3.5 Pts DI

Rigorously identify and explore the lesson learned. Rigorously discuss how the lesson learned can be integrated in your current personal development and future professional practice.

3.5 to >3.0 Pts CR

Sufficiently identify and explore the lesson learned. Sufficiently discuss how the lesson learned can be integrated in your current personal development and future professional practice.

3 to >2.5 Pts PA

Briefly identify and explore the lesson learned. Briefly discuss how the lesson learned can be integrated in your current personal development and future professional practice.

2.5 to >0.0 Pts NN

Do not or barely identify and explore the lesson learned. Do not or barely discuss how the lesson learned can be integrated in your current personal development and future professional practice.

0 Pts DNS

Did not submit.