Addressing Inconsistent Sales and Determining Continent-Specific Discounts: A Case Study of CeilBrakes Furniture Retail Company

Abstract

This paper highlights the primary business issues faced by CeilBrakes Furniture Retail Company, namely inconsistent sales across different continents. While Europe demonstrates strong sales, North America, Australia, Asia, and Africa exhibit varying levels of mediocre and low sales in terms of the quantity of products ordered. Additionally, determining appropriate discount percentages for each continent poses a challenge. To address the issue of inconsistent sales, the company aims to enhance advertising efforts, improve customer relationships, and analyze trends in continents with low sales (excluding Europe). For determining continent-specific discounts, a solution involves identifying continents with low sales and offering higher discounts accordingly. In the case of Australia, which experiences low sales, CeilBrakes should provide more significant discounts. Despite Asia and Africa already having high discounts, their sales remain low. This situation calls for considering factors beyond retail price reductions, such as cultural influences. To facilitate easier viewing and analysis, a dashboard has been developed to visualize the aforementioned issues. The dashboard enables the identification of trends and patterns, empowering the company to make informed decisions in addressing the observed problems.