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.

Questions

  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.

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

11770+ Orders Delivered

4.9/5
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

How The Monetary Policy In Malaysia Could Affect The Asian Countries Essay Sample Malaysia
The Monetary Policy in Malaysia could have significant impacts on the economies of other Asian countries. Given Malaysia's important role within the region, and indeed, globally, decisions to adjust the…
Essay Sample
CTU 211 Sains Dan Teknologi Islam/Science and Technology in Islam Assignment Sample UiTM Malaysia
CTU-211 Sains dan Teknologi Islam is an Islamic University that's able to keep up with the modern age. CTU-211 deals with core technology and sciences from a perspective of faith,…
Education

UP TO 15 % DISCOUNT

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