Inventory Analysis

This inventory analysis, titled "Inventory Analysis," examines product performance based on sales, profit, cost, and classification across various categories and countries.

Key Metrics and Financial Performance (2021 Data):

Total Items Analyzed: 104.

Total 2021 Revenue (Top Items): $467,486.81.

Total 2021 COGS: $268.92K.

Average Turnover: 0.94.

ABC Classification (2021 Revenue):

The majority of the revenue is concentrated in the high-value segment:

A [High Value] Class: Accounts for approximately $320K of the 2021 Revenue.

B [Medium Value] Class: Accounts for approximately $98K of the 2021 Revenue.

C [Low Value] Class: Accounts for approximately $49K of the 2021 Revenue.

Top Products:

Highest 2021 Revenue: GROW A FLYTRAP OR SUNFLOWER IN TIN ($33,717.97).

Highest Inventory Turnover: DOUGHNUT LIP GLOSS (1.97).

Category and Geographical Insights:

Highest 2020 Profit: Home Accessories (Approx. $110K).

Highest Average COGS: Decoration (Approx. $5.80).

Geographical Concentration: Sales volume is primarily concentrated in Europe, with the United Kingdom and a cluster of nearby countries showing the largest activity.