MGT555: In 2021, the price charged for bottled drinks/box is RM10 for passion fruit, RM8 for mango, and RM6 for calamansi: Business analytics Report, UiTM, Malaysia
|University||Universiti Teknologi MARA (UiTM)|
|Subject||MGT555: Business Analytics|
Based on the S&S Sales data set, write an analysis based on the following questions:
- In 2021, the price charged for bottled drinks/boxes is RM10 for passion fruit, RM8 for mango, and RM6 for calamansi. This price is 50% higher than the price charged in 2020. Find the following and all works/formulas must be shown in the MS Excel worksheet.
Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.
- The lowest number of orders of passion fruit, mango and calamansi in 2021.
- The highest number of orders of each type of juice in 2021.
- Average quantity sold of each type of juice in 2021
- Total quantity sold of each type of juice in 2021
- Monthly percentage change of each type of juice in 2021.
- In 2021, classify the unit sold less or equal to 300 000 units as low, greater than 300 000 but less than 600 00 units as a medium, and greater than 600 000 units as high.
- The Differences in Total Revenue of each type of juice in RM 2021 and 2020.
2. The director-owner is planning to increase the sales of the fruit juice division by 20% within six months. Based on the given data, you are assigned to recommend the most outstanding brand to achieve the objective.
The report must encompass the following items:
- Cover page
- Executive summary
- Table of Content
- List of abbreviations and symbols (if any)
- The main body
- Recommendation (if any)
- Reference list
- Appendices (including plagiarism report)
- Font: Arial 11, margin 1.5, justify alignment, apply heading and sub-heading.
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Get Help By Expert
Can I pay someone to do my assignment online? Yes, you can. At Malaysia Assignment Help With a team of highly qualified writers are skilled to provide all types of management assignment solutions at a pocket-friendly price.
Recent Solved Questions
- Danial Has been working in Kota Bharu for 5 years and has purchased a house there: COMMERCIAL LAW Assignment, UM, Malaysia
- If you were the brand manager for Kraft salad dressing, which obstacles to implementing the key integrated marketing: Integrated Marketing Communication Assignment, IIU, Malaysia
- BNRS 6222: The nursing profession plays an integral role in all aspects of emergencies, including pandemic disease: Epidemiology Essay, LUC, Malaysia
- BBM206: San Bhd manufactures and distributes glassware in Malaysia. The following ratios are based on its financial statements: Accounting and Costing Assignment, WOU, Malaysia
- Explain the history and theory and model in early childhood education. Explain the appropriate activities according: Introduction to Early Childhood Assignment, OUM, Malaysia
- OUMH1203 The purpose of this assignment is to expose students to proper essay writing skills and introduce them to the step-by-step guide to writing an essay: English for written communication Assignment, OUM, Malaysia
- In October 2020, Smart Co signed an agreement with Clear Inc. to divest the server memory business, including the memory fabrication facility: Accounting Case Study, UM, Malaysia
- ECN61104: The limitations of mainstream economics for dealing with corporate finance and pricing valuations: Financial Economics Assignment, TU, Malaysia
- LAW416: Karim ordered 100 packets of gummy bears from Julie. He instructed Julie to pack 20 packets in 5 boxes to be sent: Business Law Assignment, UiTM, Malaysia
- BQS560: Understanding and synthesizing information gained from the main source of reference. Critically appraise the information: Project Management I Assignment, UiTM, Malaysia