Hi All,

I have been tasked to calculate a 3% weighted average price increase for a few of our products according to sales volume. I have been working through this over the morning and I am having a really hard time figuring this out. I am trying to calculate the weighted price increase by taking a % of total volume for each product and then distributing it to the 3% increase, but I know that is not correct. When I set the equation up in my head I am thinking that the combinations for the price increase are infinite because there are an infinite amount of combinations I could use to determine the price increase for each product to equal 3%. I was hoping coming on here would help me out. Please help if you have any idea. Thanks.