Addressing Inconsistent Sales and Determining Continent-Specific Discounts: A Case Study of CeilBrakes Furniture Retail Company
DOI:
https://doi.org/10.58776/ijitcsa.v1i3.50Keywords:
Inconsistent sales, Data Analytics, Advertising efforts, Dashboard visualisatiAbstract
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.
References
. K. Rakhmanaliyeva, “IDENTIFYING CUSTOMER BUYING PATTERNS USING MARKET BASKET ANALYSIS,” Herald of the Kazakh-British technical university, vol. 18, no. 3, pp. 95–101, Nov. 2021, doi: 10.55452/1998-6688-2021-18-3-95-101.
. Dr. K. Poola and Dr. V. Lavakumar, “Contemporary marketing strategy: ambush marketing – with low budget, but augmented customer attention,” International Journal of Research in Marketing Management and Sales, vol. 3, no. 2, pp. 71–73, Jul. 2021, doi: 10.33545/26633329.2021.v3.i2b.81.
. X. Gao, X. Chen, and Y.-J. Chen, “Dynamic Pricing When Customers Have Time-Inconsistent Preferences,” SSRN Electronic Journal, 2021, Published, doi: 10.2139/ssrn.3968335.
. J. Goard and M. AbaOud, “Pricing European and American Installment Options,” Mathematics, vol. 10, no. 19, p. 3494, Sep. 2022, doi: 10.3390/math10193494.
. H. Dib and J. Alleil, “Single Discount Versus Double Discount: Errors in Processing Double Discount Percentage Changes,” International Journal of Academic Research in Business and Social Sciences, vol. 12, no. 6, Jun. 2022, doi: 10.6007/ijarbss/v12-i6/13995.
. B. Mohan, P. Chandon, and J. Riis, “Percentage Cost Discounts Always Beat Percentage Benefit Bonuses: Helping Consumers Evaluate Nominally Equivalent Percentage Changes,” Journal of Marketing Behavior, vol. 1, no. 1, pp. 75–107, May 2015, doi: 10.1561/107.00000005.
. K. Piasecki and A. Łyczkowska-Hanćkowiak, “On Approximation of Any Ordered Fuzzy Number by A Trapezoidal Ordered Fuzzy Number,” Symmetry, vol. 10, no. 10, p. 526, Oct. 2018, doi: 10.3390/sym10100526.
. Nanang Wahyudin, Novita Herlissha, Christianingrum, and Dwi Rizki Aldiesi, “The Utilization of E-Commerce and QRIS as Digital Payment Tools to Improve Sales Performance through Competitive Advantage in MSME,” Journal of Consumer Sciences, vol. 7, no. 2, pp. 134–147, Aug. 2022, doi: 10.29244/jcs.7.2.134-147.
. S. Bhenamesh and P. Panahi, “Examination of the Impact of Customer Relationship Management and Electronic Customer Relationship Management on Customer Loyalty and Satisfaction,” SSRN Electronic Journal, 2022, Published, doi: 10.2139/ssrn.4213932.
. D. Carter, “Regulation and ethics in artificial intelligence and machine learning technologies: Where are we now? Who is responsible? Can the information professional play a role?,” Business Information Review, vol. 37, no. 2, pp. 60–68, May 2020, doi: 10.1177/0266382120923962.
. Dr. R. Jain and Dr. N. Mital, “ANALYZING CUSTOMER FEEDBACK FOR IMPROVED SERVICE QUALITY USING BINARY LOGISTICS REGRESSION MODEL,” Administrative Development “A Journal of HIPA, Shimla,” vol. 8, no. SI-1, pp. 183–198, Oct. 2021, doi: 10.53338/adhipa2021.v08.si01.11.
. R. Miller and A. Fang, “Business Intelligence Leveraging Regression Models, Artificial Intelligence, Business Intelligence and Strategy,” SSRN Electronic Journal, 2023, Published, doi: 10.2139/ssrn.4453875.
. J. Lorincz and Z. Klarin, “How Trend of Increasing Data Volume Affects the Energy Efficiency of 5G Networks,” Sensors, vol. 22, no. 1, p. 255, Dec. 2021, doi: 10.3390/s22010255.
. O. S. Donaires, L. O. Cezarino, L. B. Liboni, E. M. S. Ribeiro, and F. P. Martins, “Multivariate data analysis of categorical data: taking advantage of the rhetorical power of numbers in qualitative research,” Quality & Quantity, Jan. 2023, Published, doi: 10.1007/s11135-022-01589-1.
. E. Yom Tov and I. Hochberg, “A Large-Scale Observational Analysis of Social Media Data Reveals Major Public Misperception of the Attainability of Drastic Weight Loss by Dieting,” Obesity Facts, vol. 16, no. 2, pp. 141–148, Dec. 2022, doi: 10.1159/000528803.
. G. Phillips-Wren, M. Daly, and F. Burstein, “Reconciling business intelligence, analytics and decision support systems: More data, deeper insight,” Decision Support Systems, vol. 146, p. 113560, Jul. 2021, doi: 10.1016/j.dss.2021.113560.
. R. M. Czekster, T. Webber, A. H. Jandrey, and C. A. M. Marcon, “Selection of enterprise resource planning software using analytic hierarchy process,” Enterprise Information Systems, vol. 13, no. 6, pp. 895–915, Apr. 2019, doi: 10.1080/17517575.2019.1606285.
. Flordeline A. Cadeliña, “Efficacy of Real-Time Transaction Processing System,” Journal of Communication and Computer, vol. 18, no. 2, Feb. 2021, doi: 10.17265/1548-7709/2021.02.003.
. B. Panja, “Mobile Data Warehouse - Creating Multi-Cluster Web Application which will Track the Entire Process of Data Warehouse,” International Journal for Research in Applied Science and Engineering Technology, vol. 6, no. 5, pp. 2409–2413, May 2018, doi: 10.22214/ijraset.2018.5395.
. Y. Lu and X. Zheng, “6G: A survey on technologies, scenarios, challenges, and the related issues,” Journal of Industrial Information Integration, vol. 19, p. 100158, Sep. 2020, doi: 10.1016/j.jii.2020.100158.
. “Business Intelligence and Data Mining: Opportunities and Future,” European Journal of Business and Management, Jun. 2021, Published, doi: 10.7176/ejbm/13-11-01.
. A. Rybakova, “Formation of data of the modular building infor-mation model in olap format,” Construction and Architecture, vol. 11, no. 1, pp. 21–21, Mar. 2023, doi: 10.29039/2308-0191-2022-11-1-21-21.
. L. Bondarchuk, “FEATURES OF TECHNOLOGICAL SYSTEM MANAGEMENT CONSULTING,” Market Infrastructure, no. 35, Sep. 2019, doi: 10.32843/infrastruct35-21.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Huyanah Baghati
This work is licensed under a Creative Commons Attribution 4.0 International License.
Attribution 4.0 International
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
