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 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 Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Mix Analysis FC v Actual

Community Blog - Latest Posts

TOGAF is a certification that is handed over by The Open Group. It is an open corporate architecture means used to improvise upon the business effectiveness across the world’s leading business set-ups. Aspirants wishing for a successful career in corporate architecture must go for the TOGAF certification in order to explain the...
My Certification Journey – Avoiding a CBAPtism by Fire. Industry Certification has always been one of my career goals. Ever since being first introduced to Business Analysis, the discussion of being certified by the most recognized industry body in this field, the IIBA, has been a consistent topic. This was only reinforced when I was first in...
BPMN 2.0 is a modelling standard that has been around for 10 years now and although it has its foibles it has been recognised as the best for capturing the business logic behind real-life scenarios.  What most people don’t realise is that the standard itself is supported by an XML definition of its objects. What does this mean? Essent...

 



 

Copyright 2006-2021 by Modern Analyst Media LLC