Business-Finance Integrated Analytics

Data: 2024-2026
Revenue
$8,963,534
vs PY: +0.74%
Gross Profit
$2,809,846
vs PY: -1.46%
Net Profit
$2,080,888
vs PY: -3.93%
Inventory Value
$1,560,581
vs PY: -7.82%
COGS
$6,153,688
vs PY: +2.08%
Gross Margin
31.3%
vs PY: -3.47%
Net Margin
23.2%
vs PY: -4.64%
Cash Balance
$3,589,506
vs PY: +31.79%
Revenue, Cost & Profit Trend Analysis
Inventory vs Cash Flow Comparison
Profit Breakdown Waterfall
Customer Structure Contribution
Sales Quantity
62,686
vs PY: +1.48%
Customers
50
vs PY: 0%
Operating Expenses
$448,178
vs PY: +3.58%
Gross Margin
31.3%
vs PY: -3.47%
Sales Amount
$8,963,534
vs PY: +0.74%
Avg Order Value
$179,271
vs PY: +0.74%
Transport Cost
$280,780
vs PY: -0.95%
Net Margin
23.2%
vs PY: -4.64%
Sales Order Trend Analysis
Sales Operations Metrics Breakdown
Multi-Dimensional Sales Decomposition
Revenue
$8,963,534
vs PY: +0.74%
Gross Profit
$2,809,846
vs PY: -1.46%
Net Profit
$2,080,888
vs PY: -3.93%
Inventory Value
$1,560,581
vs PY: -7.82%
COGS
$6,153,688
vs PY: +2.08%
Gross Margin
31.3%
vs PY: -3.47%
Net Margin
23.2%
vs PY: -4.64%
Cash Balance
$3,589,506
vs PY: +31.79%
Customer Structure Pareto Chart
Customer Quadrant Matrix Analysis
Star (High GM, High NM) Growth (Low GM, High NM) At Risk (Low GM, Low NM) Premium (High GM, Low NM)
Sales Quantity
62,686
vs PY: +1.48%
Inventory Quantity
15,895
vs PY: -98.85%
Operating Expenses
$448,178
vs PY: +3.58%
COGS
$6,153,688
vs PY: +2.08%
Sales Amount
$8,963,534
vs PY: +0.74%
Inventory Value
$1,560,581
vs PY: -7.82%
Transport Cost
$280,780
vs PY: -0.95%
Gross Margin
31.3%
vs PY: -3.47%
Product Profitability Matrix
Product ABC Analysis
Product IDSales AmountCumulative Sales Cumulative %ABC Class
P04 $2,017,844 $2,017,844 23% A
P01 $1,845,851 $3,863,695 43% A
P02 $1,784,319 $5,648,014 63% A
P05 $1,701,680 $7,349,694 82% B
P03 $1,613,840 $8,963,534 100% C
Total$8,963,534 $8,963,534100%-
Product Inventory Turnover Comparison
Product Decomposition Tree
Purchase Quantity
78,581
vs PY: +2.79%
Sales Quantity
62,686
vs PY: +1.48%
Inventory Quantity
15,895
vs PY: -98.85%
COGS
$6,153,688
vs PY: +2.08%
Purchase Amount
$7,714,286
vs PY: +3.78%
Sales Amount
$8,963,534
vs PY: +0.74%
Inventory Value
$1,560,581
vs PY: -7.82%
Gross Margin
31.3%
vs PY: -3.47%
Supplier Purchase/Sales/Inventory Comparison
S10
Purchase Qty7,848
Sales Qty6,232
Inventory Qty1,616
Supplier Purchase Contribution Impact
Supplier Purchase Dependency
Supplier Price Comparison (Box Plot)
Jul 2024
All filters reset to defaults