Contribution to margin movement

vendredi 31 janvier 2014

I'm stumped at how to approach this problem and was hoping someone could enlighten me.



If I had sold $100 of a product and made a 20% profit up until a specific day.



The next day, made three sales;

A) $20 making a $5 profit

B) $50 making a $30 profit

C) $30 making a $15 profit.



So now, in total, I've sold $200 worth making a total profit $70 or a margin of 35%.



The margin delta of 1500 bps, is there a way to show what each sale contributed to that. E.g. A) -300bps B)1000 bps and C) 800bps. I've tried isolating each sale but I don't want order to be a factor.





0 commentaires:

Enregistrer un commentaire