How can I see Gross Profit and Margin by Supplier?

Knowing your Gross Profit and Margin by each supplier can help you to:

  • Decide which suppliers to continue to work with 
  • Negotiate better pricing with your suppliers

To see Gross Profit by Supplier

  1. Run the Favourite Sales (Item) - Margin by Customer
  2. Change the Sales Date Range to the desired period
  3. Change Analyse by to Supplier - To see Supplier as the Rows

    Analyze_by_Supplier_-_.png

  4. Drill down on One Supplier to see Margin by Item by Clicking on the Supplier Name

    Drill_Down_by_Supplier.png
    or
  5. Analyse by Item and Group by Supplier to see Margin by all Items sub-totalled by Supplier


    Group_by_Supplier.png

  6. Use Compare type report to compare GP and Margin to any prior period

    Screen_Shot_2019-04-15_at_9.44.09_am.png

To learn more about creating Compare Type reports - Click Here

www.BI4Cloud.com

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?