Google Answers Logo
View Question
 
Q: Mathematical question? ( No Answer,   1 Comment )
Question  
Subject: Mathematical question?
Category: Science > Math
Asked by: mit06-ga
List Price: $5.00
Posted: 21 Apr 2006 08:07 PDT
Expires: 21 May 2006 08:07 PDT
Question ID: 721332
how to calculate the weight?

	Actual Volume	Budget Volume	Variance
ProductA	8	5	        60%
ProductB	20	15	        33%
Total	        28	20	        40%
	Actual Revenue	Budget Volume	Variance
ProductA	100	85	        18%
ProductB	400	350	        14%
Total	        500	435	        14.9%
	Actual Revenue/Volume	BudgetRevenue/Volume	      Variance   weight
ProductA	12.5	           17	                        -26%      X
ProductB	20	          23.33	                        -14%      Y
Total	       17.86	          21.75	                        -17.9%

My Questions is how can i calculate the weight(X and Y) for variance
of revenue/volume?
X and Y should satisfy the following equation :
-26%X+(-14%)Y=-17.9%
Answer  
There is no answer at this time.

Comments  
Subject: Re: Mathematical question?
From: unkul-ga on 23 Apr 2006 12:22 PDT
 
Isn't the answer simply the proportional weightings of product A and B?

If so, X+Y=1.
You already know that -26%X-14%Y=-17.9%

By using algebra:

14Y = 17.9 -26X
14Y = 17.9 - 26(1-Y)
12Y = 8.1

Y = 0.675

so X = 0.325

And just to check, (-26% x 0.325) + (-14% x 0.675) does equal -17.9%

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy