Thread: 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?

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?
Any ideas please?

There is no optimum since you don't know how much promotion costs or what the return is against product line revenue.

That is this is an ill-posed problem and whoever asked it need to go away and rethink what they really want.

CB