BCO6008

BCO6008

4^th Mar 2023

Assessment 1 Part 1

1. What are the top 10 items that have largest sales in revenue and quantity?

In order to have revenue growth, we need to find out the top sale products to focus on innovation, advertisement, and sale strategy

2. What store type has the largest total revenue and quantity?

Among a few store types, there are some store types having more revenue and sales than the other. We need to find out to see what type is more efficient to have proper actions for the rest to catch up with the top store type.

3. What are the top 3 suppliers have the least total cost?


4. What are the top 2 suppliers have the largest total revenue?

3&4 is to find out what suppliers are the most profitable business to run sale/ promotion campaign. The supplier who has most revenue but least cost will be the role model for the other suppliers to improve their performance

5. What are the top 3 location that supplied largest quantity

To find out what locations have most stock to consider logistic matter as well as to assess the efficiency in terms of supply chain and distribution management

6. What are the top 3 months have the most sales in revenue

To predict trends during the year. Also to know what are the peak months and have good preparation on sale, stock and staff during the period.

7. What product has the most comments I dont like this product

To understand customers need, we need to know what they do not like and make improvement to better suit market

8. What product has the most comments I like this product

To understand what the popular product is to have proper marketing and strategy to promote, attract customers to expand scale as well as growth