I have the total sales of a product for 5 years.
I have the % growth by year for each of the 5 products that combine the total
and i need to find the %split of the total, by product.
i tried solving by simultaneous equations but these seem to give negative numbers.
Possibly because the source data is inaccurate.
I wondered if this was the best way or if there were any way to estimate the splits?
The table above shows the percentage increase of each product (a-e)
from the previous year, and the total sales of a-e for that year.
I need to know the split of a-e in making up the total for each year. Ideas?
I'm not familiar with the term %split.
Would you explain it . . . or give us the original wording of the problem?
I see a lot of messy algebra/arithmetic in our future.
Do the same for all five products and revise the chart.
Add down the columns and create a system of five equations.
Solve the system and determine the original number of each product.