Product Profitability Analysis dashboard

The Product Profitability Analysis dashboard enables analysis of product's profitability for a certain year/month and year-to-date. Knowing which product decreases and increases in margin helps business owners identify risks and make the appropriate decisions. An arrow indicator is available in the KPI for comparison against previous year of these metrics: Invcd Net Amt, Total Disc Amt, Gross Profit 1, and Gross Margin 1 Pct.

Report and KPIs

The dashboard contains the Product Profitability Analysis report and these KPIs:

  • YTD Gross Margin 1 Pct
  • YTD Invcd Net Amt
  • YTD Total Disc Amt
  • YTD Gross Profit 1
  • LYTD Gross Margin 1 Pct
  • LYTD Invcd Net Amt
  • LYTD Total Disc Amt
  • LYTD Gross Profit 1

These KPIs use the Invoice date as date basis for analysis and the Sum aggregation. Amounts are expressed in the company currency.

Currency information is also displayed on this dashboard.

Filters

These standard filters are available:
  • Facility
  • Warehouse (Config. 1)
  • Year/Month
  • Sales Organization
  • Customer (Config. 1)
  • Customer Geography
  • Payer
  • Sales Order Type
  • Promotion
  • Item (Config. 1)

The Year/Month filter is a mandatory filter that is defaulted to current year/month. This filter shows up to current year/month +6.

Related topics