Use a sample CRM export to analyze sales, gross profit and margin by time, product and customer. Perform a what if? analysis. This exercise is located in our learning center: https://www.arithmix.com/knowledge/builder-101.1-using-crm-data
Checkout the video guide:
Want the answers?
Easy question - What is the total year sales of 101 Chocolate product to Customer D101 Border?
Answer: $2,375,900
Medium question - What is the total gross profit for January 2023 sales of all products to the west region customers in Version 1?
Answer: $11,223
Hard question - What is the Gross margin % for total year, all product sales to all customers in Version 2?
Answer: 8.6%
Want a a copy of the app?
Builder 102.1 Using CRM data completed