World132_PM_Task06

We want to assess the net opportunity scores across markets. 

First, compute Market_Attractiveness_Index for each market. The formula is:
0.25* Average Sustainability_Score + 0.2* Average Revenue_CAGR_23_25_% + 0.15* Average Gross_Margin_% + 0.15* Average Formulation_Complexity_Score + 0.15* Average Ecommerce_Logistics_Maturity_Score - 0.1* Average Regulatory_Complexity_Score

Next, calculate each competitor's share in the market (Competitive_Share_%). The formula is:
(Revenue $M-2020 of the co...

1. The market with the highest Net_Opportunity_Score is Mexico, with a score of 31.90.
2. The difference between the highest and lowest Net_Opportunity_Score markets is 5.32.