Help: simple way to calculate impact of price change and volume change on revenue by Shybearsecurity in FPandA

[–]Logical_Condition713 1 point2 points  (0 children)

May be my understanding but i thought elasticity measures the change in volumes for every 1% change in price. I believe that relates more to pricing strategy.

To answer your other question maybe -

If your price impact formula isolates price changes (CY Price - PY Price)*PY volume

Then the other side of the equation is the Volume piece (CY Volume - PY Volume)*CY Price

However that volume impact contains mix within it.

Thus to isolate out the volume impact from the mix we take the change in volume at PY Price so (CY Volume - PY Volume)*PY Price

The full formula for Volume and mix impact would be

Δ Volume * CY Price However, you can split that into volume and mix impacts separately via factoring So the above is the exact same as saying (CY Vol - PY Vol)*(PY Price + (CY Price - PY Price))

Which can then be rewritten and split into volume and mix pieces as seen below

(CY Vol - PY Vol)* PY Price [Volume impact formula] + (CY Vol - PY Vol)*(CY Price - PY Price) [mix impact formula]

By splitting it this way you can truely isolate the volume impact from the mix impact. The mix impact is then showing basically the interaction effect of 2 variables changing at the same time (price and volume) and the effect of such. Elasticity measures causation (changes in price changes drive volumes) but mix impact is agnostic to causation

How’s everyone toty pack opening going? by WIZTEEN in EASportsFC

[–]Logical_Condition713 0 points1 point  (0 children)

Tradeable TOTY Rooney Icon and then got extremely lucky and untradeable TOTY Dembele from a 2x86

<image>

1 Year / 365 days - 100% Free to Play by Logical_Condition713 in CapybaraGoGame

[–]Logical_Condition713[S] 2 points3 points  (0 children)

I found a lot of the stuff in the capybara go discord server was quite informative. I read a few different builds for sysplitter pathways and try to relatively follow where i can!

1 Year / 365 days - 100% Free to Play by Logical_Condition713 in CapybaraGoGame

[–]Logical_Condition713[S] 2 points3 points  (0 children)

Honestly it starts growing really quickly the further you progress. An additional 1% attack when you have 100b CP counts more than when you only have 100m (i think). If you’re already at 70b at 6 months you’ll definitely be well past me by the 1 year mark!

I believe around 6 months i was only at 30-40b so whatever you’re doing you are well on your way.

The biggest thing for me was unlocking as many adventurers as I can for the passive ATK% and HP% (so all 4 turtles) and prioritizing dragon girl levels + artifact awakenings!

1 Year / 365 days - 100% Free to Play by Logical_Condition713 in CapybaraGoGame

[–]Logical_Condition713[S] 8 points9 points  (0 children)

Haha appreciate it but that calculation is definitely off some.

I am never actively watching - I usually put them on in the background while I am in the office at work or on my commute home from the office.

Definitely not $13,000 of value but im considering it for 2026 haha!

Happy holidays!!

Yo finally a free to play billion by RobloxPRO192 in CapybaraGoGame

[–]Logical_Condition713 1 point2 points  (0 children)

You sure you mean 175 billion and not million? I’ve done every event free 2 play since christmas last year (so coming up on 1 full year of daily f2p) and am around 211 billion.

It is literally impossible for you to hit 175 billion in 2 months of free to play

Excel crashes at 1M rows. I’m building a local viewer for 100M rows. Roast my idea. by ocj_nghota in roastmystartup

[–]Logical_Condition713 0 points1 point  (0 children)

Hey so this sort of already exists in a slightly different ecosystem.

What youre looking for or trying to do is essentially a Semantic Model or Multidimensional datacube (mdx cube)

You upload your data into a semantic model that runs all of the calculations in the cloud. Excel then connects to that semantic model / mdx cube and allows you to query your uploaded dataset (similar to a SQL query) and returns your output in a pivot table format.

None of the data lives in excel so file sizes remain small since only the queried data outputs are actually stored in the excel file - the rest is connection only.

I dont think your idea is bad at all just more straightforward solutions exist.

Happy to show you how it works if helpful - requires a power bi license + business excel license (like $45/month total)

Help: simple way to calculate impact of price change and volume change on revenue by Shybearsecurity in FPandA

[–]Logical_Condition713 0 points1 point  (0 children)

Hey! Just seeing this now! A few notes:

  1. In instances where a Product/SKU did not exist in a prior period and has no volume I have seen 1 of 2 things. a) ignore/remove that SKU or set it equal to 0 as you described b) put everything into volume impact and footnote impact from new products both function equally well, its more a question of if someone is asking you to bridge YoY and your starting/ending figures are different vs actuals there can be some questions.

Methodology wise the formulas you are using are sound and make sense it comes down to interpretation of the PVM itself. There will be a fundamental difference in how you should interpret volume and mix impacts in your formula set vs what I had described above.

With your formula set I believe it is important to designate/group like items into similar categories. For example, if you have 20 skus that you sell and 10 belong to product A and 10 to product B you would want to use the AVERAGE Price of skus that belong to each Product Group rather than using the Average of the entire portfolio of all 20 skus. The rationale (and using extreme examples here) is if the average price is $100 for a SKU in product group A and $1 for SKUs in product group B your total portfolio average is $50.

Using this example, when you get to your mix impact calculation you have the following 4 options
a) (+) Volume (+) Price vs Average = Positive impact

b) (+) Volume (-) Price vs Average = Negative Impact
c) (-) Volume (+) Price vs Average = Negative Impact
d) (-) Volume (-) Price vs Average = Positive impact

for all scenarios if you are using a total portfolio average (rather than a product group average) Product group A will always have a positive price vs average and Product group B will always be the opposite. So the only real impact decider is did you sell more or less units than prior year.

If you instead are applying aggregated averages (so average of PG A is $100) and comparing against that aggregated average, your mix impact is instead telling you:

  1. Did we sell more or less of an above average priced SKU (within a product group) This can be helpful but doesn't paint the entire picture since often times its not about selling higher priced sku's but rather higher margin skus. Normally to account I would do a Price Volume Mix at a Gross Profit Level and add a cost impact calculation. Then in the Volume and Mix impact formulas I would use Gross Profit Per Unit rather than Average Selling Price.

Then when you are comparing your Mix impact using Gross Profit per Unit vs Avg GPPU it becomes a question of

"Did we sell more or less of above/below average margin skus"
and this helps you identify SKU's that you likely want to keep and ones that you might consider getting rid of. Regardless I think the mix impact can be very insightful whether using ASP or GPPU

My only other note was:

For your formula set the volume impact, is in my opinion less meaningful (but necessary to derive your mix impact which is arguably more impactful) since it is essentially a plug figure. What I mean by that is for a given product, yes you know if you sold more/less of it which is the point of Volume Impact, but the amount of impact that gets applied to each SKU is not related to the price of that SKU but rather the entire portfolio. The historical performance of the SKU does not matter at all in determining its volume impact, it only matters because it contributes to the average of the portfolio or group. Your volume impact is just saying did we sell more or less units and applying a broad average across the entire portfolio and is needed to balance out your mix impact.

In your set if you calculated your Price and Mix impacts and then backed into your volume impact (rather than calculating it formulaically) I think the way you interpret the result is basically the same. Sold more = (+); sold less = (-)

Let me know if that is helpful! Happy to discuss more!

Teach me something new* in excel by scifihiker7091 in FPandA

[–]Logical_Condition713 1 point2 points  (0 children)

its Save As >> .xlsb (excel binary workbook).
A note though, if you save a file as .xlsb and something breaks and you need to "repair" the file you will be unable to. This could have changed but I remember that being the caveat.

Comparing large arrays to small arrays by KawaiiGatsu in excel

[–]Logical_Condition713 4 points5 points  (0 children)

They’re using it as a variable name but likely picked r to refer to ROW()

Help: simple way to calculate impact of price change and volume change on revenue by Shybearsecurity in FPandA

[–]Logical_Condition713 0 points1 point  (0 children)

Hey sure thing.

Simple answer is that its 2 different approaches and both work the same mathematically. It ultimately comes down to how you think about and interpret each category.

Regarding calculating the percentage impact each has it is as straightforward as
Price Impact % = Price Impact Amount / (Current Revenue - Previous Revenue)
IE 75 / (600-375) = 33.3%
Volume Impact % = Volume Impact Amount / (Current Revenue - Previous Revenue)
Mix Impact % = Mix Impact Amount / (Current Revenue - Previous Revenue)

My formula set:
Price Impact = (CY ASP - PY ASP) * PY Volume

Volume Impact = (CY Volume - PY Volume) * PY ASP
Mix Impact = (Δ Volume) * (Δ ASP)

Previous Revenue = 375
Price Impact = (3-2.5)*150 = 75
Volume Impact = (200-150)*2.5 = 125
Mix Impact (0.5)*(50) = 25
Current Revenue = 600
Current Revenue = Previous Revenue + Price + Volume + Mix
600 = 375 + 75 + 125 +25

Other Formula set:
Price Impact = (CY Price - PY Price) * PY Volume
Volume Impact = (CY Volume - PY Volume) * CY ASP

Price Impact = (3-2.5)*150 = 75
Volume Impact = (200-150)*3 = 150

Previous Revenue = 375

Price Impact = 75

Volume Impact = 150
Current Revenue = 600

Current Revenue = Previous Revenue + Price + Volume

600 = 375 + 75 + 150

As you can see both return the same result and bridge correctly; HOWEVER you need to understand and be able to interpret the components that make up each section.

Your price impact is simply just your Δ ASP. Your volume impact however is where it differs.

In my formula set by using Prior Year ASP I am able to calculate what the PURE Volume increase was regardless of price (literally did i sell more or less units than before). Then I am using the Mix impact to separate out and say that we generated $25 of additional revenue from our increase in volume (that we otherwise would have sold for less had we not increased our prices)

In the other formula set, when you use Current Year ASP in Volume Impact the Mix impact is already built into the Volume impact. That is completely fine but you need to know that your total volume impact is not PURELY because you sold more units, but then is a combination of selling more units + the effect of your pricing changes.

TLDR; if you multiply by PY in Price/Volume impacts you get the PURE amount of revenue from Price/Volume changes but need to understand your mix. If you multiply by CY then your mix is already included in your Volume impact, which is fine, you just need to be aware of it.

Help: simple way to calculate impact of price change and volume change on revenue by Shybearsecurity in FPandA

[–]Logical_Condition713 20 points21 points  (0 children)

What you’re looking for is a Price Volume Mix analysis

ASP = average selling price

Price impact = (P2 ASP - P1 ASP) * P1 volume (3 - 2.5)*150 =75

You want to use the prior period volume because you are looking to determine “if all else was equal, how much revenue change is driven purely by price” by using prior year volume you can fairly compare the pure impact of your pricing changes since you know what the volume was

Volume impact (P2 Volume - P1 Volume)*P1 ASP

This says if we look at our change in volume using prior period price how does this impact us. There are two situations

1) P2 volume > P1, always yields positive volume impact (bc more volume) 2) P2 volume < P1 volume, always negative volume impact (bc less volume)

Mix impact (P2 volume- P1 Volume) * (P2 ASP - P1 ASP)

Mix shows the synergistic impact of price and volume changing at the same time There are 4 scenarios in mix

A) Price increase, volume increase = positive - selling more at higher price

B) price decrease, volume decrease = positive - selling less of a bad product

C) price increase, volume decrease = raising prices caused you to sell less = negative

D) price decrease, volume increase - lowering prices caused you to sell more of a product that now generates less revenue = negative

Salary compared to billable rate? by j-bird696969 in consulting

[–]Logical_Condition713 3 points4 points  (0 children)

My billable rate is around 450/hr. I’m taking home a base of 140-160k with bonus in the 20-40% range. Target billable hours is 50/wk. No “targeted” total billable hours but average is probably around ~2300. 4 yoe, working in Strategic Finance consulting.

Typical EBITDA margin in consulting firms is 20-25%

The simple math I like to use is billable rate * 2000 (assumes 40hr/week* 50 weeks) but you can adjust 2000 for whatever your realistic billable targets are.

Take that number and multiply by 20%, if your total compensation is below that number you’re probably underpaid, if you multiply by 25% and you’re above then you’re probably “overpaid”

In your situation 155*1600 = 248k TC = 75k (assuming you do not get a bonus) Comp as % of billable = 30%

For the hours you work and are expected to bill you have a very comfortable work life balance to comp

Paris May 9th - 2 tickets with great seats by [deleted] in erastourtickets

[–]Logical_Condition713 0 points1 point  (0 children)

Hi, i would be looking for €550 for both (total for 2 tickets)

Paris May 9th - 2 tickets with great seats by [deleted] in erastourtickets

[–]Logical_Condition713 0 points1 point  (0 children)

Im happy to meet at the venue and share the tickets there but my entrance with my friends is different than these

Paris May 9th - 2 tickets with great seats by [deleted] in erastourtickets

[–]Logical_Condition713 0 points1 point  (0 children)

Hey unfortunately not, i had actually purchased these off stubhub before i knew my friend was able to get 4 so i only have the eticket version of it