Algebra Question
A company wants to look at their YoY margin % changes on an absolute basis. (ex. if margin in '22 was 50% and margin in '23 was 80%, break out the drivers of the 30% change). I'm having difficulty getting to an answer because when you isolate revenue Yoy to find COGS driver, you get a different answer than if you isolate cogs driver to find revenue impact first.
I tried to simplify an example below to show the mechanics. In (x-y)/x = z, x=revenue, y=cogs, and z= profit margin %.
In scenario A (of (x-y)/x=z), x=4 and y=2, so z= 2/4 or 50%. In scenario B (of (x-y)/x=z), x=5 and y=1, so z= 4/5 or 80%. Z went from 50% to 80% between scenario A and B. Z increased 30% points. Can you break the 30% change into drivers? How much did the change in x contribute to the 30% change and how much did the change in Y contribute to the 30% change? The answer must add up to 30%. (example x=15% y=15%)
Answer
- The questioner was satisfied with and accepted the answer, or
- The answer was evaluated as being 100% correct by the judge.
![Erdos](https://matchmaticians.com/storage/user/100028/thumb/matchmaticians-3empnt-file-5-avatar-512.jpg)
-
Let me know if you need any clarifications.
-
This is great, thank you. The only discrepancy I see is that to find the change in z due to the change in y, you multiplied 1/5 by (y1-y2). If you would have multipled by (y2-y1), or 1-2, the answer would have been negative. Which is correct? Multiplying by (y1-y2) or by (y2-y1)?
-
You are right. I revised my solution to include the minus sign. It should make much more sense now. Thank you for the coffees!
-
-
Thank you!
- answered
- 1572 views
- $5.00
Related Questions
- ALGEBRA WORD PROBLEM - Trajectory of a NASA rocket
- How does the change in $b$ in the quadratic formula $ax^2+bx+c$ move the parabola in an inverted version of the quadratic function?
- The Span and Uniqueness of Solutions in a Parametric Matrix
- How to properly write rational exponents when expressed as roots?
- Three questions on Vectors
- Reverse this equation/function (2d to isometric)
- If both $n$ and $\sqrt{n^2+204n}$ are positive integers, find the maximum value of $𝑛$.
- Find $x$, if $\sqrt{x} + 2y^2 = 15$ and $\sqrt{4x} − 4y^2 = 6$.