代做EFIM10014: Quantitative Analysis in Management COURSEWORK 2024代写Java程序
- 首页 >> WebEFIM10014: Quantitative Analysis in Management
COURSEWORK 2024
Assignment format |
The Group Project Presentation is one video consisting of: 1. 10 – 11 minutes (50% of EFIMM0144) |
Assignment deadlines |
Group Project Presentation deadline is Tuesday, 10th Dec at 1pm |
Mode of submission |
The link to the video should be submitted to the submission points with the EFIMM0144 Contribution Statement for the video. |
This assessment is assessing the following unit learning outcomes:
1. Demonstrate knowledge and understanding of the role of quantitative analysis in generating value from data.
2. Apply basic statistical techniques to business and management problems.
3. Use a variety of visual models to represent statistical results in the presentation
4. Use Excel for data analysis and explain in the presentation
Assignment:
Kheirat is a company that sells skincare products all over Asia. The company has designated geographic sales territories, each the responsibility of a single sales representative who services a number of retail outlets within their territory. The company wants to find out which factors influence the quantity of sold units and the impact each factor has on sales. For this, a random sample of 100 sales territories of the firm’s sales organisation was drawn. Information was collected on the number of units of the product sold, along with values for seven possible predictor variables, in each territory.
Sales of the skincare products (in units sold) were hypothesised to be a function of the following variables:
1. Promotion expenditures are the related costs that incurred from advertising and promotional activities (Promotion expenditures; in $);.
2. The duration for which the territory's sales representative has been working with the company (Representative tenure in month).
3. The percentage of the territory’s market potential that the company has captured (Market penetration rate in %)
4. The total sales volume of products in the same category within the territory (Territory sales).
5. The number of retails stores the sales representative is responsible for in the territory (Number of stores covered).
6. The average rating given by customers in the territory (Customer satisfaction score).
7. The number of interactions between the sales representative and top management (Executive interactions).
The Excel spreadsheet “QAM CW DATASET 2024.xlsx” contains data for the 100 sample sales territories.
Requirement and Format:
You are tasked to conduct the data analysis to provide the CEO with insights about what drives or predicts sales. For this, you should write a summary of your findings and make recommendations for the company, in management/nontechnical terms, so the CEO knows what to focus the company’s attention on.
The CFO has also announced their interest in your findings because they are hoping for a mathematical model to predict future sales. Unlike the CEO, the CFO is a bit of a statistics whizz and will critically examine your analysis and assumptions.
Start with the summary of the findings and recommendations arising from your analysis. This is aimed at the CEO, so it has to go first, as they won’t read the rest of the report. The summary and recommendations to the CEO should constitute the main part of the presentation first use easy understanding language.
The second part of the report, which could be the technical appendix, should demonstrate and explain all the steps you have taken in your analysis, the obtained model of what drives sales, and which assumptions you have made and tested. Remember this needs to be statistically accurate, as the CFO will examine it critically and might recommend scrapping your results to the CEO if they do not trust your procedure. This part presentation must include tables and graphs with some relevant explanation.
The project presentation should include the following sections:
Overall summary of the presentation report.
Report to the CEO part, including the findings and recommendation.
Report to the CFO part, including the method used to evaluate the impact of variables in the prediction sales analysis, model validation or assumption test.
You will be assessed on:
• The correctness of your models and statistical analysis
• The correctness and details in your interpretations of ALL the output
• The clarity of the interpretation of your analysis for management’s (CEO)
understanding
• The structure and presentation style. of the report
• Recommendations arising from the analysis and suggestions for future work
• Conducting any relevant extended analysis beyond the basic brief (especially
if based on your own independent reading with relevant sources)
EFIM10014 Marking Criteria
|
Distinction (100-70) |
Merit (69 - 60) |
Pass (59 -50) |
Pass (49 -40) |
Fail (39 -0) |
Pitch |
Clarity and Engagement: The pitch is exceptionally clear, concise, and engaging. |
Clarity and Engagement: The pitch is clear and engaging, capturing the audience's attention for most of the presentation. |
Clarity and Engagement: The pitch is generally clear and engaging, capturing the audience's attention for most parts. |
Clarity and Engagement: The pitch lacks clarity. |
Clarity and Engagement: The pitch is unclear. |
Knowledge and Understanding |
The student shows excellent understanding of the requirements of the assignment. Recommendations made to the CEO are relevant and useful. |
The student shows very good understanding of the requirements of the assignment. Relevant recommendations based on the findings are made to the CEO but might be rather basic. |
The student shows good understanding of the requirements of the assignment. Some recommendations are made to the CEO, but the student have made some confusing or irrelevant statements, or recommendations made are too basic. |
The student shows a satisfactory understanding of the requirements of the assignment. The recommendations made to the CEO are too brief or confusing. |
The student shows poor understanding of the requirements of the assignment. They fail to demonstrate awareness of the proper analysis to predict what impacts sales. Because the analysis is incorrect, the student fails to make proper recommendations to the CEO, or there is no attempt to make recommendations. |
Analysis and Approach |
The obtained/chosen model is statistically correct. |
The obtained/chosen model is statistically correct. |
The student might have missed an important step that affects the final model built, but a reasonable statistical analysis is demonstrated. |
They have run some analysis to find out what impacts sales, but they might not have conducted all relevant steps. |
There is overall very little/inadequate statistical analysis and what is present is either incorrect or very confusing. |
Organazaion and Strucutre |
There is a clear division between the section for the CEO and that for the CFO. The student differentiates between what explanation (and output interpretation) goes into the CEO report and what goes into the technical appendix for the CFO. Good/correct writing style. of management and technical report with due regard to target audience for each part. |
There is a clear division between the section for the CEO and that for the CFO. The student attempts to differentiate between what explanation (and output interpretation) goes into the CEO report and what goes into the technical appendix for the CFO, but the presentation style/language used for the CEO might include a few technical terms. |
There is a clear division between the section for the CEO and that for the CFO. The language used for the CEO and CFO is almost the same (student has barely distinguished between the two audiences). |
The report might not follow the recommended structure: CEO report followed by a technical appendix/section for the CFO and thus student has not distinguished between the two audiences. |
The report is not follow the recommended structure: CEO report followed by a technical appendix/section for the CFO and thus student has not distinguished between the two audiences. |
Ues of Source |
References are included IF the student presents information outside the lecture material on Blackboard. |
References are included IF the student presents information outside the lecture material on Blackboard. |
References are included IF the student presents information outside the lecture material on Blackboard. |
References are included IF the student presents information outside the lecture material on Blackboard. |
References are included IF the student presents information outside the lecture material on Blackboard. |
Style. and Presentation |
The presentation is well-structured and includes appropriate sections. |
The presentation is well-structured and includes appropriate sections. |
The essay might not be very well-structured. However, there is clear presentation of tables and figures. Writing in PowerPoint is presented to a good standard and tables/grpahs are not in correct order. |
The writing may lack fluency and contain errors in understanding and misinterpretation of concepts. |
The report does not follow the recommended structure and has a weak or no discernible structure. |