Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Mix Analysis FC v Actual
Previous Previous
 
Next Next
New Post 10/9/2020 6:42 AM
User is offline AshleyWatson
1 posts
No Ranking


Mix Analysis FC v Actual 

Hi All 

I am trying to understand mix analysis properly and how to calculate variances from FC to Actuals. This example is based on services, this could be any service but we will go with Car Sales being the Product and the service being a car wash taken out at the time of purchase.

There are 3 variables. Price, Volume of cars sold and Uptake of the service. Price, volume and uptakes could change from FC to Actuals through several means but the variance analysis is the key point here. 

I have attached a google sheet an example of how I can get from FC to Actual Income through 4 different methods, all of which I believe are wrong. 

I'm looking for a solution to properly perform variance analysis for these 3 variables from FC to Actual Income. 

Let me know if you can help!

Thanks

https://docs.google.com/spreadsheets/d/1qAk3J-NjNIDJbny_xqyZQBiDh5DhuMOd/edit#gid=1014107644

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Mix Analysis FC v Actual

Community Blog - Latest Posts

Is Agile a reason to avoid documentation? I bet this question shows up again and again while working with product requirements. On one side, we have got long specifications, complicated diagrams, mystical technical design, too many prototypes and pretty obvious for engineers user guides (do we really need so much?). On the other side, can we actual...
The cloud-native application development has helped enterprises all around the globe reduce time-to-market, enhance performance, and develop agility and flexibility. Several enterprises are achieving these results by migrating their systems or traditional monolithic applications to the cloud. But to gain from the real benefits of cloud technology, ...
So you’ve found the perfect time and place to study and you’re ready to finally get some work done. You’ve pulled out your laptop, your textbook, and your notes, and four different highlighters. After five minutes of reading your textbook, you start zoning out and thinking about puppies. Then, you go on Tumblr and look at cut...

 



Upcoming Live Webinars




 

Copyright 2006-2021 by Modern Analyst Media LLC