Executive Overview
1. Identify Key measures and provide aggregate values for each of them 2. Create and calculate profitability KPI; show the contribution of each product line for the generated profit 3. Identify the profitability of the company across different states of the country; are they above the benchmark? 4. How is each product line performing in terms of the sales?
Profitable Products: Find the most profitable products sold by the organization
5. Find the products that are high in sales quantity and profitable to the company 6. Compare all the products based on profitability KPI and the number of quantities sold by the company 7. Find the product that provides high profit amount irrespective of profit ratio
Target Market/Customers
Using the most profitable products data, identify target customer profiles/market using the attributes available to us about the customers 8. Marital Status 9. Gender 10. Age group/generation, and 11. Commute distance
see Excel attached
0 comments