1. ## interesting question

Hi,
I have a set of data that belong to a company revenue generated through many different products.
In total 2000 producst.
So the data is like this
Product Revenue
Product 1 $2000 The list goes on to Product 2000 and revenue varies. The question is to determine which products to promote. There is no set budget. So based on revenue the question asks to suggest which products to promote. (Company principle is to promote higher revenue making products) but how do you determine the most optimum point. I sorted all valued from high to low and created a chart. Then added a linear trend line. And I was going to take the intercepting point as the optimum point? Any ideas please? 2. Originally Posted by kotum45 Hi, I have a set of data that belong to a company revenue generated through many different products. In total 2000 producst. So the data is like this Product Revenue Product 1$2000

The list goes on to Product 2000 and revenue varies.
The question is to determine which products to promote. There is no set budget.
So based on revenue the question asks to suggest which products to promote. (Company principle is to promote higher revenue making products) but how do you determine the most optimum point.
I sorted all valued from high to low and created a chart. Then added a linear trend line.
And I was going to take the intercepting point as the optimum point?