Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Mix Analysis FC v Actual
Previous Previous
 
Next Disabled
New Post 10/9/2020 5: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 Disabled
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Mix Analysis FC v Actual

Community Blog - Latest Posts

m_anst
m_anst
What Does Success Look Like? I challenge Business Analysts to view requestors’ requirements as an opportunity to define success. Too often, teams fall into a trap focused on requestors’ prescriptive requirements that are meant to serve as roadmaps for developers and testers. When you limit your view of requirements to this prescripti...
0 Responses
Mariya Kotsupalova
Mariya Kotsupalova
They say the best criteria of Business Analyst’s success are a happy customer (business) and a happy engineering team. But what does it mean? How can we break down happiness and measure it? These are precisely the questions my 8 BAs team and I tried to answer this year. The result was a surprisingly efficient pair of surveys we developed and ...
0 Responses
Rajesh-N
Rajesh-N
Explore the Benefits of RPA's Adoption Across Segments In the past few years, we have seen steady growth in Robotic Process Automation (RPA). It gathered momentum in 2019 and became a hot topic in IT and business circuits in 2020. The power of process automation will be felt even more strongly, propelling its adoption as a replacement f...
0 Responses






Copyright 2006-2020 by Modern Analyst Media LLC