I would like to distribute the total forecast value based on the actual contribution as well as the user defined contribution.
I have Prod category A,B,C having sales 100,300 and 50, their contribution is 22%,67% and 11% respectively.
user will input the total forecast sales as 1000, than distribute the total based on the actual contribution. Lets say, now user wants to overwrite the prod category A to 25%, than Prod Cat A to 250, remaining 750 will be assign to the actual proportion to B and C.
Prod
sale
% Contr
Forecast
Forecast
450
1
1000
1000
A
100
0.222222
222.2222
250(1000*25/100)
B
300
0.666667
666.6667
642.857143(750*(300/(300+50)
C
50
0.111111
111.1111
107.142857(750*(50/(300+50)
Similarly, if the user input 25% to A and 50% to B than assign remaining to C. users will input the A,B and C values in different combinations.
