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

    Compare_-_margin.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
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk