Mexico Toy Sales.

ANALYSIS

The sales transaction for two consecutive years 2017 and 2018 makes up this dataset. 1 million units were sold within this period, generating a total sale of $14.44 million with a total cost of $10.43 million and a profit of $4.01 million.

April is the month with the highest number of sales with $1.5 million and 112.7K units sold, the month with the lowest sales is October with $623.9K and 47.9K units sold.

Toys product category records the highest sales of $5.1 million from 267.2K units sold. The total cost of this product category is about 78.4% of the total sales. Electronics, Games, Sports & Outdoors product categories all made $2.2 million in sales but Electronics has the lowest total cost making the highest profit of $1 million with the sale of 134.1k units which is the lowest number of units sold in the product category within this period.

Lego Bricks has the highest sales and cost of $2.4 million and $2.1 million, the cost is 87.5% of the sales. Comparatively, the total cost of Colorbuds is about 46.6% of its total sales, generating a profit of $834.9K than Lego Bricks of about $298.7K.

In this period, stores in location Downtown has the highest number of sales, making a total sale of $8.22 million, which is about 56.9% of the total sales from all stores. In this location, there are 29 stores, Ciudad de Mexico 1 is the store with the highest sales of $433.56K, the total cost of $322.3K and profit of $1111.3K from the sales of 33.5K units. Airport location has the lowest total sales with $1.3 million, contributing 9% to the total sales from 3 stores. Ciudad de Mexico 2 is the store with the highest sales in this location.

DASHBOARD

RECOMMENDATIONS

• There was a drastic reduction in sales from October. October and November had the lowest sales with sales rising gradually in December. An investigation should be done to know the reason(s) for the poor sales for the last 3 months of the year.

• Toys, Arts & Crafts, Sports & Outdoors have a significant amount of cost associated with sales; cost reduction strategies should be in place for this category. Electronics generated a good amount of profit despite selling the lowest units, awareness should be raised to improve sales.

Dataset details

Playground - Maven Analytics

Name - Mexico toy sales

Click here