PRODUCT. SALES. CONTRIBUTION
A. $250. 25%
B $350. 35%
C. $100 10%
D. $300 30%
I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a particular product.
Ex:
Product - A
Current Sales - $250
Current Contribution - 25%
New Sales VOlume - $50
Updated Sales - $250 + $50 = $300
Updated Concentration = $300/$1050 = 29%
I have tried what if analysis data table approach, but it only works for product A. Need suggestions on how to automate this process in excel. Is what if analysis best approach to this problem?
A. $250. 25%
B $350. 35%
C. $100 10%
D. $300 30%
I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a particular product.
Ex:
Product - A
Current Sales - $250
Current Contribution - 25%
New Sales VOlume - $50
Updated Sales - $250 + $50 = $300
Updated Concentration = $300/$1050 = 29%
I have tried what if analysis data table approach, but it only works for product A. Need suggestions on how to automate this process in excel. Is what if analysis best approach to this problem?