Vending Machine Data Visualization

Business Overview

The vending machine company is having several vending machines from various locations in Central New Jersey. The locations include a library, a mall, an office location, and a manufacturing location. The company would like to find multiple insights from the vending machine data to improve its performance. The dataset is recorded from 5 different machines for 8 months.

Limitation: The dataset date’s time is only from January to August 2022.

Data Analysis Process

• Revenue Trend
  The Vending Machine revenue from 1st January — 31st August in 2022.

Insight :
1. Total Revenue in this period is $12.584
2. Revenue has an upward trend from January to August.
3. The highest revenue was generated in July as much as $2285,4.
4. There is a big revenue drop from July to August about 10%.

• Revenue Trend by Machine
  The total revenue by Vending Machine type from 1st January — 31st August 2022.

Insight:
1. GuttenPlan has the biggest revenue over the period as much as $4886,1.
2. Revenue has an upward trend from January to August.
3. The highest revenue was generated by GuttenPlan in July as much as $915,5.

• Revenue Comparison by Machine in August
  The Total Revenue by Vending Machine type compare to between 1st to 31st Aug in 2022 and 1st to 31 July in 2022.

Insight:
1. GuttenPlan has the biggest revenue in August. However, BSQ Mall 1366 decreased drastically as much as -37%.

• Transaction VS Prices Trend by Category
  The Transaction and Prices trend of Vending Machine by Category from 1st Jan to 31 Aug in 2022.

Insight:
1. Food has the highest transaction number in total from January to August.
2. The Transaction affected the price movement over the period.

• Sales Trend by Category
  The sales total by category from 1st to 31st Aug in 2022.

Insight:
1. The sales have an upward trend between January and August in 2022.
2. Food has the highest sales number sold over the period and Carbonated placed the second position.

• Revenue Prediction Trend
  The Vending Machine Revenue prediction from 1st September to 31st December in 2022.

Insight:
1. The vending machine has 60% increase over the last four months.
2. December has the biggest revenue over the period, which is $3302.5.

Get Saprilian Hidayat’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

For further insight, you can go through Dashboard

Conclusion:

1. The Revenue were increasing steadily from January to July, but it goes down by 10% in August.
2. Gutten plan became the most profitable vending machine in New Jersey due to it having the highest total revenue for almost over the period, which is about 4886,1 sales units (38,8% of total revenue).
3. Based on machine efficiency, GuttenPlans took the first position and was followed by EB Public in the next machine.
4. Food became the favorite category type for New Jersey’s people.
5. The number of transactions affected the price fluctuation and sales number of each type of Vending Machine.

Recommedations:

1. Increase the number of Gutten plan and EB Public vending machines consisting of 3 categories (food, carbonate, and noncarbonate).
2. Upselling food and carbonated products to increase the number of transactions much more.
3. Evaluating RCoil and Working Hours at the BSQ Mall and Earle Asphalt Vending Machine.
4. Re-strategizing sales at the BSQ Mall and Earle Asphalt Vending Machine.

Author Copyright © 2023 Saprilian Hidayat