Question: how to calculate weighted average margin in excel?
Answer: Calculate the Weighted Average Contribution Margin Multiply the contribution margin per unit for each product by the number of sales, and then add the totals. Divide the total of individual contribution margins by the total number of unit sales.