Analysis of sales performance in vending machine case studies using data analysis processes

This study aims to analyze sales performance in a case study of a vending machine company in Central New Jersey in 2022. This type of research is a type of quantitative descriptive approach obtained from sales datasets. The indicators in case are transtotal per month per quarter in difference locations, total quantity per product categories, transtotal per machines, transtotal per payment type, and average price per product category. Using a data analysis process which consists of understanding business problems, data cleaning processes, data visualization processes, and providing recommendations based on the insights that have been obtained. The results showed that there was a decline in sales in the Q3 period from July to August of 10%. Based on the visualization data obtained insight that the locations that have the highest total sales are Gutten Plans, EB Public Library, BSQ Mall, then the lowest is Earle Asphalt. The best-selling product categories are food, carbonated, non-carbonated, then water and customers use more cash payment types. So that conclusions can be drawn to improve vending machine sales performance in the next period based on insight from the metrics that have been obtained. Such as adding vending machines in locations where there is a lot of demand, diverting products that are not selling well with products that have the highest sales. Relocating machines that have the lowest sales to more profitable locations. Adding non-cash payment types and lowering the selling price of mineral water due to the small demand.