actuals sum 135 3254 KEUR
customer a 110 KG 2092 KEUR
custmer b 21 kg 974 KEUR
customer c 4 KG 188 keUR
forcast sum 147 3377 KEUR
customer a 106 KG 1993 KEUR
customer b 27 KG 736 KEUR
customer c 14 KG 648 EUR
for actuals cust A has 2092/110=19 eur/KG and in forecast 1993/106= 18,8 a deviation of +0,2 eur/KG. How much is +0,2 eur/ KG giving impact of total deviation vs forecast? Actuals 3254/135=24,1 eur/KG minus forecast 3377/147= 22,9 eur/KG = +1,2 eur/KG.
Do yo have a formula that fix problem? I want to know the cust A impact of the total deviation vs forecast. Thanks Regards Marylin
customer a 110 KG 2092 KEUR
custmer b 21 kg 974 KEUR
customer c 4 KG 188 keUR
forcast sum 147 3377 KEUR
customer a 106 KG 1993 KEUR
customer b 27 KG 736 KEUR
customer c 14 KG 648 EUR
for actuals cust A has 2092/110=19 eur/KG and in forecast 1993/106= 18,8 a deviation of +0,2 eur/KG. How much is +0,2 eur/ KG giving impact of total deviation vs forecast? Actuals 3254/135=24,1 eur/KG minus forecast 3377/147= 22,9 eur/KG = +1,2 eur/KG.
Do yo have a formula that fix problem? I want to know the cust A impact of the total deviation vs forecast. Thanks Regards Marylin
