International Journal of Information Technology and Business
Vol. 7 No. 2 (2025): April : International Journal of Information Techonology and Business

Sales Data Analysis and Visualization for Distribution Optimization: Case Study: US Candy Distribution

Riska Indarwati (Unknown)
Herti Yani (Unknown)
Beny, Beny (Unknown)



Article Info

Publish Date
30 Apr 2025

Abstract

Optimization of US Candy's product distribution was conducted through sales data analysis and visualization. The main challenges identified include less strategic factory locations and high logistics costs. This research used a quantitative approach. The purpose of this analysis is to analyze the distribution pattern. Data visualization was conducted using Power BI to show the results of the analysis that New York is the highest selling city with total sales of $10,945.89, with the leading product being Wonka Bar - Scrumdiddlyumptious ($2,718). The consistent increase in sales trend in the fourth quarter of each year, triggered by celebrations such as Halloween, special promotions, and holidays can be utilized to develop future marketing and product inventory strategies. A distribution optimization strategy is recommended to minimize logistics costs and delivery time, by moving distribution to the Wicked Choccy's factory with a distance of 8237.2 km. Marketing strategies such as discounting best-selling products and bundling system for low-selling products are proposed to improve market competitiveness. The resulting interactive dashboard implementation is expected to assist the company in making more accurate and efficient data-based decisions.

Copyrights © 2025






Journal Info

Abbrev

ijiteb

Publisher

Subject

Computer Science & IT

Description

Information Technology Management Information System E-commerce Computational Intelligence Information Infrastructure Cyberspace Enterprise Resource Model Business Intelligence Diffusion and Future IT Network Management IoT ...