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.
Questions
- 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)
- Introduction
- The main body
- Recommendation (if any)
- Conclusion
- 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
- LAW1014: Laurie who is 16 years of age, decides to leave home She travels to Kuala Lumpur, where she quickly finds herself a full-time job: Business law Assignment, SU, Malaysia
- Describe the breaches of US sanctions committed by ABC in respect of the three (3) sanctioned countries: Anti-Money Laundering & Counter Financing of Terrorism Practices Assignment, ICTA, Malaysia
- MAT455: Plot the region using the mathematical application and Evaluate the given integral: Further Calculus for Engineers Assignment, UiTM, Malaysia
- you are required to develop a computer program with Python programming language to try and solve it: THEORETICAL ASPECTS OF COMPUTER SCIENCE Assignment, MUM
- LLB102A: The High Court in Sri Kajang Rock Products Sdn Bhd v Mayban Finance Bhd [1992] 1 CLJ 204 stated at p 206: LAW OF CONTRACT A Assignment, HU, Malaysia
- OUMH1303: Describe Effective Verbal and Non-Verbal Language in Expressing Formal: English For Oral Communication Assignment, OUM
- In response to the judicial outcome of the Afghan Hijackers case, then-future Prime Minister of the United Kingdom: Public Law Course Work, UiTM, Malaysia
- TSE307/05: Describes Logical Reasoning which includes Critical Thinking in a formal and daily task performance: computational Assignment, OUM, Malaysia
- MBA6073: Decide demand and supply factors impacting the launch of the new product service based on the organization that you have selected incorporating short-run and long-run factors: Managerial Economics Assignment, QIUP, Malaysia
- EEE4333: Demonstrates the ability to engage in independent learning of modern tools for the programming of embedded systems: Embedded system Coursework, SU, Malaysia