Question: Based on ProCleanse data set, write an analysis based on the following questions: In 2020, the price charged for face mask/box is RM10 for Anne,

Based on ProCleanse data set, write an analysis based on the following questions:

  1. In 2020, the price charged for face mask/box is RM10 for Anne, RM8 for Bella, and RM6 for Charlotte. This price is 50% higher than the price charged in 2019. Find the followings and all works/formula must be shown in MS excel worksheet:

No

Questions

Lowest number of orders of Brand Anne, Bella, and Charlotte in 2020.

Highest number of orders of Brand Anne, Bella, and Charlotte in 2019.

Average quantity sold of each brand in 2020 and 2019.

Total quantity sold of each brand in 2020 and 2019.

Monthly percentage change of each brand in 2019 and 2020.

The months when sales of each brand are greater than 300 000 units in 2020 and 2019.

Classify the unit sold less or equal to 300 000 units as low, greater than 300 000 but less than 600 00 unit as medium, and greater than 600 000 units as high.

Total Revenue of each brand in 2020 and 2019.

The Differences of Total Revenue of each brand in RM 2020 and 2019.

Total Revenue generated from all brands in 2020 and 2019.

  1. The director-owner is planning to increase the sales of face mask by 45% within six months. Based on the given data, you are assigned to recommend the most outstanding brand to achieve the objective.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!