What's the best way to calculate the potential impact of BOGO discounts on my profit margins?

Calculating the impact of BOGO discounts on profit margins entails a multifaceted analysis. Consider factors like cost per unit, anticipated sales increase, and potential cannibalization of full-priced sales. Craft a detailed spreadsheet comparing scenarios with and without the BOGO offer. This analytical approach empowers informed decision-making, safeguarding healthy profit margins.