A fruit supplier sells 3 types of fruits. The company has 3 salespersons.
Here are the sales quantity of each person for each fruit. The total sales figure is available. (this is all the available data)
Because of different reasons, e.g. season, event, bulk purchase, etc. The unit sales prices were all different (and has no record in place).
In the new year, management wants to estimate how many new (in addition to the old) business these 3 salespersons can bring in.
Assuming each new customer is $100, How many new customers that David, Mike, and Lilly can generate in the new year?
I. to calculate the weight of the sales of each fruit type in 2020 II. multiple the fruit quantity each by the calculated weight (I) III. Sum all the II of each person IV. to calculate each person's III's weight in all IIIs.
The IV of each person is the expectations of new customers, i.e. David is expected to bring in 3 customers, Mike will bring 5 etc.
Does this idea make sense? What would be a better choice and why?