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


Universiti Teknologi MARA (UiTM)

*We aren't endorsed by this school

Assignment Type

Individual Assignment


MGT555: Business Analytics

Uploaded by Malaysia Assignment Help



Based on the S&S Sales data set, write an analysis based on the following questions:

  1. 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.

Stuck in This Assignment? Deadlines Are Near?


  1.  The lowest number of orders of passion fruit, mango and calamansi in 2021.
  2. The highest number of orders of each type of juice in 2021.
  3. Average quantity sold of each type of juice in 2021
  4. Total quantity sold of each type of juice in 2021
  5. Monthly percentage change of each type of juice in 2021.
  6. 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.
  7. 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:

  1. Cover page
  2. Executive summary
  3. Table of Content
  4. List of abbreviations and symbols (if any)
  5. Introduction
  6. The main body
  7. Recommendation (if any)
  8. Conclusion
  9. Reference list
  10. Appendices (including plagiarism report)
  11. Font: Arial 11, margin 1.5, justify alignment, apply heading and sub-heading.

Get 30% Discount on This Assignment Answer Today!

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.



Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
Convincing Features
Plagiarism Free Report
On-Time Delivery
Native Writers
A+ Quality
100% Confidential
24*7 Online Assistance

Get these features included in Your Assignment

Get Assistance for Assignments, online Exam, and Projects Writing