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

Answer

Request Answer of this Assignment