Interactive business review · Fictional data
Revenue grew. Why did gross profit fall?
This sample supply business sold more, but kept less gross profit after product costs. Explore the products, prices, discounts, and costs behind the change.
Fictional business and sample data. Calculations run in your browser; no business systems are connected.
The result at a glance
What supports that reading
First, put the month in context
Growth and margin do not always move together.
Net revenue and gross profit are shown in dollars. Gross margin is gross profit divided by net revenue.
Read the trend values
| Month | Net revenue | Gross profit | Gross margin | Units |
|---|
Then, reconcile the change
Where did the gross profit go?
Inspect a driver
How the bridge is calculated
The bridge is sequential: total unit volume, then product mix, list prices, discounts and channel terms, and unit product costs. Each effect uses the prior period as its reference. This shows how the numbers add up. Explaining why prices, discounts, or costs changed requires more context.
- Volume: change in total units × prior average gross profit per unit.
- Product mix: change in product unit shares × current total units × prior product gross profit per unit.
- List price: current product units × change in average list price per unit.
- Discounts: current product units × the negative change in discount per unit. Changes in channel mix are included here.
- Cost: current product units × the negative change in unit product cost.
Units are counted as individual products, not equivalent capacity or value. Calculations use unrounded values; displayed dollars are rounded. Products without a prior-period baseline cannot be attributed with this bridge.
Find the concentration
Which products changed the result?
| Product | Units | Net revenue | Revenue change | Gross profit | Profit change | Margin |
|---|
On a small screen, scroll the table horizontally. Select a product to inspect its unit economics.
Check the route to market
How do the sales channels compare?
These cards always show the whole business by channel. Select one to filter the review above; channel terms affect the discount driver.
Turn findings into a review agenda
What should the team investigate next?
Suggested questions based on the selected view. The data supports prioritization; commercial decisions still need context from the people responsible.
Make the data checks visible
Can we trust this view?
The source includes one exact duplicate. It is removed by record ID before calculation. The optional simulation removes the channel assignment from one August trade record; its sales remain in the business total.
Inspect the viewed source records
These are monthly product/channel aggregates, not individual invoices. Monetary inputs are stored in cents. The export contains these same deduplicated records for the two compared months and selected channel.
| Period | Record ID | Product | Channel | Units | List / unit | Net / unit | Cost / unit |
|---|
Definitions and limits
- Net revenue = units × realized price after discounts.
- Gross profit = net revenue − product cost. It excludes operating expenses, financing, tax, and other costs.
- Gross margin = gross profit ÷ net revenue. Margin change is shown in percentage points.
- Period comparisons use adjacent full sample months. No seasonality or causal relationship is inferred from three months.
- No returns, tax, freight, or currency conversion is modeled. A real engagement would agree these definitions and reconcile to the relevant source systems.
- The sample snapshot is fixed. It is not a live refresh, benchmark, or projection of client performance.
Which number needs a better explanation?
We can start with a recurring report or a focused business question. Tell us what you need to decide and where the data comes from.