Cash Cows, Discounts, and Delays

Which product categories truly make money, which lose value through discounts, and where returns and delays eat into profit. An interactive store-management dashboard.

Exact totals across 34,500 orders (Sep 2023 to Sep 2025). Filters operate on a representative 8,000-order sample; filtered counts and totals are projected to the full population, rates and averages computed directly.

Overview

Total Revenue
-
Net revenue across all orders
Total Profit
-
Sum of per-order profit
Orders
-
Total transactions
Return Rate
-
Share of orders returned
Delayed Orders
-
Share delivered late
Avg Discount
-
Mean discount applied
Revenue Trend by Month

Monthly net revenue across the two-year window

Revenue Share by Category

Electronics dominates the revenue mix

Profit by Category

Grocery is the only category that loses money

Revenue by Region

How sales spread across the five regions

Returns vs Delivery Delays

Operational risk at a glance

Categories

Top Cash Cow
-
Highest profit category
Profit Concentration
-
Top category share of total profit
Loss-Making
-
Categories below zero profit
Revenue by Category

Ranked net revenue per category

Profit by Category

True profit (sum of per-order profit); Grocery below zero

Profit Margin % by Category

Separates big-but-thin from small-but-rich categories

Revenue vs Profit by Category

Size of sales next to value created

Average Order Value by Category

Basket strength per category

Profit Share (Profitable Categories)

Dependence on the cash cow; Grocery excluded (loss)

Discounts

Full-Price Revenue Share
-
Revenue from undiscounted orders
Margin: 0% vs 20-30%
-
Margin erosion from deep discounts
Revenue/Order Drop
-
Full-price vs deepest discount bucket
Orders by Discount Bucket

How much trade is discounted, and how deeply

Avg Revenue per Order by Discount Bucket

Deeper discounts bring lower, not higher, spend

Avg Margin by Discount Bucket

Margin falls steadily as discount deepens

Avg Discount by Category

Where markdowns concentrate

Revenue: Full-Price vs Discounted

Reliance on markdowns for revenue

Volume vs Margin by Discount Bucket

Deeper discounts do not bring the volume to justify the margin loss

Operations

Return Rate
-
Share of orders returned
Delayed Orders
-
Share delivered late
Most Delayed Category
-
Highest count of late orders
Return Rate by Category

Fashion and Electronics return most

Delayed Orders by Category

Late deliveries concentrate in the biggest categories

Average Delivery Time by Category

Days from order to delivery

Delayed-Order Rate by Region

Where logistics struggle most

Profit vs Delayed Orders by Category

Do delays hit the high-profit categories hardest?

Return Rate by Region

Geographic return hotspots