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:

  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.

Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.


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

Online Exam & Assignment Writing Services

11770+ Orders Delivered

5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

CBE424 Introduction To Chemical And Bioprocess Engineering UITM Assignment Sample Malaysia
CBE424 Chemical and Bioprocess Engineering is an introductory course. It covers fundamental principles and applications of chemical and bioprocess engineering in various industries, including pharmaceuticals, food processing, and environmental management.…
CSC339 Practical Training Assignment Sample UITM Malaysia
In order to graduate, students need working experience in an information processing environment. This subject will introduce them to the challenging work environment of the future by putting together a…


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

Get Assistance for Assignments, online Exam, and Projects Writing