fallingfirst
New member
- Joined
- Aug 7, 2022
- Messages
- 1
Would greatly appreciate any help on this finance maths problems I have been trying to solve for days.
The total change in PGM% from 2022 to 2021 is 3%. How can I calculate the relative contribution of each product to this 3% change?
I.e. if I were to add up the PGM% variance of all products, it should sum up to the total % variance.
The total change in PGM% from 2022 to 2021 is 3%. How can I calculate the relative contribution of each product to this 3% change?
I.e. if I were to add up the PGM% variance of all products, it should sum up to the total % variance.
2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | Variance | |||
Sales | COS | PGM | PGM % | Sales | COS | PGM | PGM% | PGM% | |||
Product A | 1000 | 200 | 800 | 80% | 800 | 200 | 600 | 75% | -5% | ||
Product B | 800 | 150 | 650 | 81% | 500 | 80 | 420 | 84% | 3% | ||
Product C | 650 | 300 | 350 | 54% | 700 | 200 | 500 | 71% | 18% | ||
Total | 2450 | 650 | 1800 | 73% | 2000 | 480 | 1520 | 76% | 3% |