Revenue, cost, volume and budget
- —
- —
Monthly actual vs budget
Categories vs budget
Bar = actual · tick = budget · click to filterRevenue by store location
— physical stores on the map. — left off because their coordinates fall outside their country: —
Revenue bridge: budget to actual
Category breakdown
Actual vs budget · click a row to filterRevenue = sales amount, cost = total cost, volume = units sold (FactSales). Budget = the Budget scenario in FactSalesQuota; budget cost = budget revenue − budget gross margin. Amounts in the data’s currency (USD). The store map shows physical stores only (DimStore.GeoLocation); online, catalog and reseller sales have no store location, so the map’s totals are lower than the figures above.
Top 5 best sellers
Ranked by revenue · bar = actual · tick = budget · click for detailsTop 5 to scale
Click a product for its detailsProduct specification
—
—
Specifications
- Brand
- —
- Manufacturer
- —
- Category
- —
- Subcategory
- —
- Color
- —
- Class
- —
- Size
- —
- Weight
- —
- Stock type
- —
- List price
- —
- Unit cost
- —
- On sale since
- —
- Status
- —
- Product key
- —
Revenue per year
Top 5 at a glance
Click a row for its specification| # | Product | Brand | Subcategory | List price | Avg price | Units | Revenue | vs budget | Margin % | Returns |
|---|
Best sellers are ranked by revenue (FactSales sales amount) within the year and category picked above; “All” ranks across every category. Share of revenue = the product’s revenue over all revenue in that slice. Avg selling price = revenue ÷ units; list price and unit cost come from DimProduct. Discount given = discount amount ÷ (revenue + discount). Return rate = units returned ÷ units sold. Budget = the Budget scenario in FactSalesQuota.