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

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.

Questions

1.  Lowest number of orders of passion fruit, mango and calamansi in 2021.
2. 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 of 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.

Answer

Request Answer of this Assignment