__STYLES__

ToyStore Insights: Playful Profits & Inventory

Tools used in this project
ToyStore Insights: Playful Profits & Inventory

About this project

  • Which product categories drive the biggest profits? Is this the same across store locations?

Amongst the product category, Toys is bringing in the biggest profits, and it’s the same across all store locations, followed by Arts & Crafts.

  • Can you find any seasonal trends or patterns in the sales data?

There’s fluctuation between the months in 2022 and 2023 with December 2022 and April 2023 being the highest in sales.

  • Are sales being lost with out-of-stock products at certain locations?

There’s a total of $414.33k lost sales at certain locations.

  • How much money is tied up in inventory at the toy stores? How long will it last?

There’s a total of $188.1million tied up at inventory at toy stores, and it lasts for about 274.79 months.

Discussion and feedback(2 comments)
comment-1395-avatar
Neda Noormohammadi
Neda Noormohammadi
23 days ago
How did you calculate the Total Inventory Value over time, considering we do not have any date-related information in the inventory data?
2000 characters remaining